Forum Discussion
Conditional format two cells with different values
Hi there, hope someone can help me please. I would like to add two cells values together, and if they equal 8 it should turn green. So I know how to do the conditional formatting so that the cells turns green, but that's only for either a whole sheet or a single value, not if two cells equal one figure. Is there a formula I should use?
1 Reply
Hi Cherise,
If, for example, you values are in A1 and B1 you may apply the rule with the formula
=($A1+$B1)=8
to A1:B1
