Select all the rows to be CF'd

FormatCFFormula is: =$D2="No"

Note the $ sign to fix the column D but not the row number.

Format the Font to Red.

Note: do not let Excel change the $D2 to $D$2

Edit if that's the case.


Gord Dibben MS Excel MVP

On Wed, 7 Mar 2007 07:55:26 -0800, Joe M.
wrote:

I want to change the color of a row's text based upon the value "No" in the
same row. I want to extend this for the other rows on the same sheet. For
example:
If cell D2="No" then text in row 2 is red.
If cell D3="No" then text in row 3 is red.
etc...
The sheet is already filled so I need to apply this formatting afterward.
Can someone help please?