Need formula for difference in numbers
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?
Answers

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

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.
Help Article Resources
Categories
Check out the Formula Handbook template!