How do I set a Conditional Format for ROWs based on the value of .
 

I want to format a row based on the value of another cell. eg If cell N10
25 then fill (hi-light) row 10 (or A10:N10) with red colour.

Select A10:N10 or the entire row 10 if desired.

FormatConditional FormattingFormula is:

=$N1025

Note the $ sign must be entered to make Column N absolute.

Pick a suitable red color from the FormatPatterns chart and OK your way out.

Gord Dibben Excel MVP

On Tue, 28 Dec 2004 16:27:02 -0800, "Wes T" <Wes
wrote:

I want to format a row based on the value of another cell. eg If cell N10
25 then fill (hi-light) row 10 (or A10:N10) with red colour.

Thankyou Gord

The $ sign !!!!!! Spent hours searching help etc. Knew it had to be
something simple.

Thanks again.

Craig West

"Gord Dibben" wrote:

Select A10:N10 or the entire row 10 if desired.

FormatConditional FormattingFormula is:

=$N1025

Note the $ sign must be entered to make Column N absolute.

Pick a suitable red color from the FormatPatterns chart and OK your way out.

Gord Dibben Excel MVP

On Tue, 28 Dec 2004 16:27:02 -0800, "Wes T" <Wes
wrote:

I want to format a row based on the value of another cell. eg If cell N10
25 then fill (hi-light) row 10 (or A10:N10) with red colour.

Thanks for the feedback Wes.

Gord

On Tue, 28 Dec 2004 17:11:02 -0800, "Wes T" <Wes
wrote:

Thankyou Gord

The $ sign !!!!!! Spent hours searching help etc. Knew it had to be
something simple.

Thanks again.

Craig West

"Gord Dibben" wrote:

Select A10:N10 or the entire row 10 if desired.

FormatConditional FormattingFormula is:

=$N1025

Note the $ sign must be entered to make Column N absolute.

Pick a suitable red color from the FormatPatterns chart and OK your way out.

Gord Dibben Excel MVP

On Tue, 28 Dec 2004 16:27:02 -0800, "Wes T" <Wes
wrote:

I want to format a row based on the value of another cell. eg If cell N10
25 then fill (hi-light) row 10 (or A10:N10) with red colour.