Highlighting an entire row using conditional formating
 

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

Highlighting an entire row using conditional formating
 

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.

Highlighting an entire row using conditional formating
 

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
--

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"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.

Highlighting an entire row using conditional formating
 

"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.

Highlighting an entire row using conditional formating
 

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.

Highlighting an entire row using conditional formating
 

Try
=$A11

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

"Sam H" wrote:

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.