color coded cells

[stereosympathy]

Does anyone know if its possible to format a row to be one color if no data is entered in it and then change to a different color once data is entered? This would be a quick way for me to reference when someone has changed data in my workbook.

 

[royUK]

Why not use Conditional Formatting, see

http://www.excel-it.com/excel_conditional_formatting.htm

To check Row2 use this Formula in the Formula is box

=COUNTA(2:2)>0

 

[SteveO59L]

Try Conditional Formatting

 

[stereosympathy]

Conditional formatting works but is there a way to expand the selection to cover the entire row? Like say I have text "Approved" in column F. If this says "not approved" I would like that whole row to turn red. Thanks for the help so far.

 

[barry houdini]

How many rows are we talking about?

If you want this to work for, say rows 1 to 10

Select row 1 and expand selection to row 10

Format > Conditional Formatting > "Formula is"

=$F1="Not approved"

select red pattern

note: you must have the $ as written

 

[stereosympathy]

Thats it! That is exactly what I was looking to do. Thanks a lot for the help!