Conditional formatting, if a1 = the value of b1 + c1 together

[marshen]

Hi all .

Looking for a way of conditional formatting 365 rows of data as follows:

IF A1 = THE VALUE OF B1 + C1 TOGETHER (format accordingly)

It's worth noting that I don't want anything to happen if B1 + C1 don't equal A1 as I have a separate conditional formatting.


I'm doing numbers so here's an example:

A B C
1 2 1 1 (I WANT THESE FORMATTING AS B1 & C1 = A1)

2 1 0 1 (I WANT THESE FORMATTING AS B1 & C1 = A1)

3 2 1 0 ( I DON'T WANT THESE FORMATTING AS B1 & C1 DON'T = A1)

Any advice is appreciated.

Thanks Mark

 

[Fluff]

Select the area you want this to work on & use the formula
=$A1=$B1+$C1

Assuming your data starts in A1