Highlighting an entire row using conditional formating

[Tom Freeman]

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

 

[Mike H]

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

 

[Sheeloo]

Use
=$A1=99
if you want to paint the formula down to other rows. You may also select
more than one row, starting at row 1 and then enter the above formula

 

[Sam H]

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

 

[Sam H]

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,

 

[Sheeloo]

Try
=$A1>1

If you are entering dates in the current century ( 1/1/2000 or later)
then you can use
=$A1>36525