View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Native Native is offline
external usenet poster
 
Posts: 17
Default 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?