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

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

"Sincere" wrote in message
...
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