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