Conditional Format Formula

  • Thread starter Thread starter Barneypo
  • Start date Start date
B

Barneypo

I want to 'conditional format' those cells in a column which are of
greater value than a certain cell which may change in value. What is
the formula please.

i.e. If any of the cells in N5:N30 are greater than cell M1 then paint
them red.

Cheers,

Barney
 
Select N5:N30
Then use:

Formula is:
=N5>$M$1



[email protected] said:
I want to 'conditional format' those cells in a column which are of
greater value than a certain cell which may change in value. What is
the formula please.

i.e. If any of the cells in N5:N30 are greater than cell M1 then paint
them red.

Cheers,

Barney
Click to expand...
 
Nope.

Select the entire range (N5:N30 which isn't 78 cells!).

Then write the formula for the activecell (usually the top cell) in the range.

Excel is pretty smart and will adjust it for all the cells in the selected area.
 
Nope.

Select the entire range (N5:N30 which isn't 78 cells!).

Then write the formula for the activecell (usually the top cell) in the range.

Excel is pretty smart and will adjust it for all the cells in the selected area.
Click to expand...

Thanks Dave, That worked. N5:N30 was only an example. I really did
have 78 cells to work with.
Barney
 
Back
Top