I'm trying to create a rule that will turn cells A through D red if cells C and D equal 0 or less.
I know how to make the rule with just one cell equaling 0, but would like to make it conditional on both equaling zero.
-
It would be extremely helpful if you indicated in your table which rows should be red. For example, what do you want to happen for row 14 (question marks)? What about if one is zero and one is blank or two blanks? Also add some negative value in the example data if that is part of the question. 👍– Blindspots ♦Commented Sep 2, 2023 at 23:58
Add a comment
|
2 Answers
Use this conditional formatting custom formula rule for the range A1:D:
=isnumber($C1) * (max($C1:$D1) <= 0)
answered Sep 2, 2023 at 16:48
Use conditional formatting
=AND($B1<=0,$C1<=0)
