Hello

S

Sincere

Hello All,

I am using Conditional Formatting on one Cell. what I am looking for is;
when any particular value evaluates to True let's say Cell D5 = "Done" then
that complete record / row should be filled with any color. I have the idea
but want to learn more clearly.

Thanks In Advance

Mumshad
 
D

David Biddulph

Use "Formula is", rather than "Cell value is", and use absolute addressing
for the column and relative addressing for the row.
 
Top