Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

excel
MS Office Version: 2013
posted by: Shalz on Tue Jan 16, 2018 at 6:01 am
Answer
Discuss

Discussion

So highlight all cells that are NOT equal to zero?
don (rep: 1989) 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.

posted by: don (rep: 1989) on Wed Jan 17, 2018 at 9:17 am
Discuss


Answer the Question

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