Forum Discussion
Cherise Fella
Sep 06, 2018Copper Contributor
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 tu...
SergeiBaklan
Sep 06, 2018Diamond Contributor
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