Conditionally format with criteria

0

How to conditionality format a column in excel to highlight cells that offset to zero That is a negative and positive value add to zero. Would like to highlight both cells

Answer
Discuss

Discussion

So highlight all cells that are NOT equal to zero?
don (rep: 1317) Jan 16, '18 at 10:22 am
Highlight cells that sum up to zero  
Shalz Jan 17, '18 at 5:17 am
Add to Discussion

Answers

0

Use a custom formula like this:

=IF(A1+B1=0,TRUE,FALSE)

Apply the conditional formatting to both cells that you want to highlight. This is for a custom formula conditional formatting.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login