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.