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?
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?