Conditional FOrmating

  • Thread starter Thread starter Maggie
  • Start date Start date
M

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.
 
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.
 
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
 
Back
Top