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
|