Assuming your key cell is in column A, and your data begins in row 2, Select
your entire range (rows and columns) from cell A2 through M1000 (or
whatever), go to Conditional formatting, change the pull down box to Formula
is, and if it is just 'any' type of entry, type the following formula into
the box:
=$A2<""
Then click on the format button and choose your formatting.
--
** John C **

"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!