Conditional Format text Excel 2003

  • Thread starter Thread starter Rhonda
  • Start date Start date
R

Rhonda

I am trying to Condtionally format cells that have two other numerical
condtions.
I'd like the last condition to be... When typing "OK" or "ACCEPT" the cell
to change green.
 
In Conditional Formatting you can 3 formats, make sure your first two are the
other numerical conditions you mentioned below and for the third make the
formula this:

=OR([cell]="OK",[cell]="Accept")
and then select your formatting

I have tested this out so if you have issues with this method please let me
know.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Question 3
Copy and Paste Conditional Formatting 3
Conditional formatting in 2007 3
Conditional Format - Excel 2007 1
Cell referencing for condtional formatting 3
conditional formatting 8
Format - Conditional Formating 3
How to get more than 3 rows in Conditional Formatting 1

Back
Top