Conditional Format Pending Text Input

N

Native

Hello,

Trying to figure out how to have conditional format (CF) activate
depending upon the text input into a cell.

I would like for the CF to be true if the user does not input "blue",
"red", or "green".

For example, if the user inputted "white", I would like the CF to make
the cell's font turn white and the pattern to turn red.

I tried a few things like:

Cell Value Is / Not Equal to =OR("blue","red","green")

but it did not work.

Any suggestions?
 
D

Dave Peterson

How about using:
Formula is: =OR(A1="blue",A1="red",A1="green")
Change A1 to the cell's address that you want.
 

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 format change 3
Conditional format of range 3
Excel Conditional Formatting 1
CF for Text 2
Three condition "if" statements 2
Conditional Formatting? 5
Conditional formatting / blank cells 4
Conditional Formatting 4

Top