Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional FOrmating
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional FOrmating
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional FOrmating
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 "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional formating | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Help Please with Conditional FOrmating | Excel Worksheet Functions |