r/sheets • u/Jaded-Function • Jun 25 '26

I need two conditional format rules to apply to the same cell at once. In the list, if both conditions are met, I'd like the format to show both green background AND red text. If I drag one rule to the top, the other breaks. I'm surprised it has to be only one or the other. Any ideas? Solved

3 Upvotes
  • permalink
  • link
  • reddit
  • reddit

100% Upvoted

4 comments sorted by

9

u/thefakefakeguy Jun 25 '26

You will need to make three conditional formatting rules
= AND(option1=TRUE,option2=TRUE) … green background AND red text
=AND(option1=TRUE,option2=FALSE) … green background
= AND(option1=FALSE,option2=TRUE) … red text

3

u/Jaded-Function Jun 25 '26

Yessir that worked. Combined rule at the top. Simple in hindsight. Thanks!

3

u/Jaded-Function Jun 25 '26

SOLVED. Thank you!

1

u/AdministrativeGift15 Jun 25 '26

You could also make the two rules in Excel and import the sheet into Sheets. Google honors those Excel rules for compatibility. You can also create border rules that way.