Mike, in your formula, what would I use in place of "99" if the space is
originally blank and I intend to enter dates there. I would like to highlight
the row when the date is entered. No specific date is expected to be entered
as it would be based on when the action occurs.
Thanks,

"Mike H" wrote:

tom

Select then row (I used row 1) then

Format|Conditional format - formula is
enter the formula
=$A$1=99
pick a colour
OK

Enter 99 in a1 and the entire row is coloured.

Mike

"Tom Freeman" wrote:

I am attempting to conditional format an entore row based on one columns
results. What is the best way to do this? Thanks.