Hi!

Suppose you want to highlight all of row 1, A1:IV1, if cell E1 is blank:

Select row 1 by clicking on the row header
Goto FormatConditional Formatting
Formula is: =$E$1=""
Click the Format button
Select the style(s) desired
OK out

If you want to change the condition to highlight the row if the cell IS NOT
BLANK, just change:

Formula is: =$E$1<""

Biff

"Nat Maxwell" wrote in message
...
Does anyone know if, and how, is possible to use Conditional Formatting
feature to automatically highlight the whole row if a specific cell in
that
row is non-blank (or blank)?
Thank you!