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
|