Select the entire sheet (A1 active)
then apply CF using Formula Is:
=OR($A1="Highway",$A1="Highway Line")
Format to taste Ok out
Test it out. Input in any cell in col A, either: Highway or Highway Line.
This will trigger the formatting for the entire row.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Maggie" wrote:
How can I use CF to change appearance of cells if say $A1 was either the word
"Highway" or Highway Line". I want these to return the same conditional
format and I would like them to utilise only one of the 3 CFs available in
Excel.
--
Cheers
Maggie