Conditional Formatting with Text

A

Alfonso

Hei gurus,

How can I tell CF to turn a cell green if the cells
contain text "great" and red if the cells
contain "unacceptable??"

TX a great deal
 
B

Bob

cell value>="great">format>patterns (choose green)
add
cell value>="great">format>patterns (choose red)
 
G

Guest

Select the range of cells

Format > Conditional Formatting:

Condition 1
Cell is Value --- equal to --- ="great"
Format > Pattern > Choose color

Click on Add to add another condition

Condition 2
Cell is Value --- equal to --- "unacceptable"
Format > Pattern > Choose color

Click OK

HTH!
 
F

Francisco

Use the "Formula is" option instead of the "Cell Value
is" option and input a formula including your cell
reference like this C3="great"

Regards
 
C

Charlie

Alfonso,

Try entering in the 'Cell is' 'equal to' ="great". Select
the format desired. Click on Add for another condition
and again 'Cell is' 'equal to' ="unaceptable" and select
the format desired.

Charlie O'Neill
 
Top