Conditional Format Formula

[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

 

[Dave Peterson]

Select N5:N30
Then use:

Formula is:
=N5>$M$1

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

 

[Barneypo]

Select N5:N30
Then use:

Formula is:
=N5>$M$1

So I need to write a formula for each cell in the column which is 78
cells in all?

Thanks,

Barney

 

[Dave Peterson]

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.

 

[Barneypo]

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.

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