Conditional Formating Background Based on If

[dsnake]

I have a spreadsheet I'd like to conditional format a cell based on an if. Here is my scenario:

1. A1 is formula that sums a population of data in number format
2. B1 and B2 get their numbers from the same population as A1 but are different formulas however B1 plus B2 should equal A1
3. What I would like to do is conditional format B1 and B2 to reflect a red background if their sum does not equal A1
4. Thanks for any help you can give.

Dave

 

[Peter_SSs]

Welcome to the MrExcel board!

Select B1:B2 and apply the Conditional Formatting shown below.

Excel Workbook
	A	B
1	20	15
2		6
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1	1. / Formula is =$A$2<>B$1+B$2	Abc

 

[dsnake]

sorry if you get this twice, thanks for the help it did work and I was able to add green if they equaled. My only other question is...why $A$2 and no $A$1

 

[Peter_SSs]

My only other question is...why $A$2 and no $A$1

It should be $A$1 - my error