View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Steve[_20_] Steve[_20_] is offline
external usenet poster
 
Posts: 9
Default 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