View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Conditional Formula-Formulas

One way:

Use the dropdowns and inputbox to enter something like:

CF1: Formula is =OR(A1="string1",A1="string2",A1="string3")
Format1: <font/<color

In article ,
Steve COR wrote:

I am putting together a conditional formatting criteria under the
"Format-Conditional Formatting" tool. I have the format of text change fonts
and color when a specific text string is entered, but am limited to three
entries/criteria.

My question is can I enter more than one string on one line within the
conditional format entry block?
tx Steve