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

  • Hi pnuts. Thanks for the comment. I tweaked my question a bit. I haven't seen anything so for in the list of questions you referenced; was there a particular question you saw in there that would be relevant? Thanks! – Drewdavid Apr 20 '17 at 22:08
  • Combine the 2 criterias for the text – yass Apr 22 '17 at 18:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.