Select the entire row by clicking on row header.

Assuming F1 is empty..............................

FormatConditional FormattingFormula is:

=$F1<""

Format to red pattern and OK.

When you enter data in F1, the row will turn red.

Note the $ sign in =$F1

That is so you can copy the CF down many rows.


Gord Dibben MS Excel MVP

On Thu, 30 Oct 2008 10:28:11 -0700, Spankie1
wrote:

I have a worksheet that I would like to fill the row red after I enter data
in one of the rows cells. Help I can't figure this out!