Sum two columns and highlight any value less then 5

[king12yan]

I'm trying to create a formula to add up two columns and highlight the cells that don't add up to 5. There are two columns for each day from the 11th to the 31st. Right now I'm just manually looking at the two columns and highlighting them if the two numbers don't add up to 5. I would love to automate that process. I attached a sample, if the two numbers don't equal 5 I want to highlight both of these cells. There is five sets of data and I need to do this on all five sets. I highlighted the first set to show what I'm looking for.

[pgschwarb]

Hi,

The easiest way is to use conditional formatting on the cell that contains the sum formula

[MarvinP]

Hi king12yan,

With 3 Named Ranges and 3 Conditional Formatting rules you have your answer in the attached.

[king12yan]

Thanks MarvinP I was able to figure out what I needed after your nug in the right directions.