Usiing a formula to Conditional Format XL2007
 

Hi all,

I'm trying to use the following formula to format a single row if any of
the cells ($AD$149 or $AL$149 or $AS$149 or $AZ$149) is equal to or
greater than the target cell ($M$149)

=OR($AD$149=$M$149,$AL$149=$M$149,$AS$149=$M$14 9,$AZ$149=$M$149)

All comments/pointers welcomed.

--
Steve

Efficiency is intelligent laziness.
- Anonymous

Usiing a formula to Conditional Format XL2007
 

Are you getting a message in the CF when you try to enter that formula?

Just reverse the operators. Instead of using = use =.

=OR($AD$149=$M$149,$AL$149=$M$149,$AS$149=$M$14 9,$AZ$149=$M$149)

That will apply the formatting if M149 is an empty cell and any of the other
cells are also empty. Do you need to account for that possibility? If so,
you can add another test that M149 is not empty/blank.

=AND($M$149<"",OR(............))

--
Biff
Microsoft Excel MVP


"Steve" wrote in message
...
Hi all,

I'm trying to use the following formula to format a single row if any of
the cells ($AD$149 or $AL$149 or $AS$149 or $AZ$149) is equal to or
greater than the target cell ($M$149)

=OR($AD$149=$M$149,$AL$149=$M$149,$AS$149=$M$14 9,$AZ$149=$M$149)

All comments/pointers welcomed.

--
Steve

Efficiency is intelligent laziness.
- Anonymous