D | E | F | G | H | etc | |
38 | Budget Total | 350 | 300 | 400 | 200 | etc |
39 | Item 1 | 200 | 200 | 300 | 100 | etc |
40 | Item 2 | 150 | 100 | 50 | 50 | etc |
<tbody>
</tbody>
Above is a small section of the spreadsheet I am working on. I am working on a budget and I want the cells for Item 1 and Item 2 to be formatted if they do not add up to the budget total.
Basically, I want the following:
IF(E39+E40)<>E38, then format E39 and E40
IF(F39+F40)<>F38, then format F39 and F40
and so on
I have got a lot of columns so I want to be able to highlight the whole row and conditionally format them all together.
I've been racking my brains all morning trying to figure it out so any help would be appreciated