Conditional Format Pending Text Input
 

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?

Conditional Format Pending Text Input
 

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


Native wrote:

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?

--

Dave Peterson