Need formula for difference in numbers

James L

Hi All -

I need suggestions for an IF formula (I think), that will showcase the difference between numbers from two columns (+/-) and needs to change color based on if the number is lower/higher than the set number, I.E - column 1 (set number) = $300, column 2 = $200, column 3 = would equal the difference -$100 and turn red. Positive numbers would turn green. - Could this also be done where the cell turns red or green vs. the text?

Leroy Noriega

You will need to create a conditional formatting to change the color of the cell/row depending on the criteria.

Paul Newcome

The formula would be a basic

=[Column 1]@row - [Column 2]@row

Then you would use Conditional Formatting to adjust the cell fill based on whether it is above or below zero.