View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Steve[_20_] Steve[_20_] is offline
external usenet poster
 
Posts: 9
Default Conditional Formatting on a Row - XL2007

Per Jessen penned:
Hi Steve


Select the entire table, and goto Conditional Format.


Use 'Formula Is', and enter this formula, where 3 is the number of the first
row in the table:


=OR($AJ3="RECALLED",$AQ3="RECALLED",$AX3="RECALLED ",$BE3="RECALLED")


Apply formatting as desired.


Thank you Per, works like a charm

--
Steve

Eat a live toad the first thing in the morning and nothing worse will
happen to you the rest of the day.
- Unknown