Conditional FOrmating

[Maggie]

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.

 

[Max]

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.

 

[Mike H]

Maggie,

I don't believe you can use wildcards in conditional formatting which would
be the obvious solution but you could try this conditional format:-

=LEFT(A1,7)="Highway"

It may suit your need but it would evaluate as true for any string beginning
with Highway not just Highway Line. If that isn't good enough then post back.

Mike