I added a conditional format to change the background based on one criteria. Based on a second criteria I would also like to change the text.
Is it possible to set these independently in the Conditional Formatting interface? If so, how? I found that when my text criteria was met, it cancelled out the background (I set the background to None on this one).
If not, what is a useful alternative way to do this (is a script necessary)?