Calculation to have cell turn red or yellow

[sduttonusa]

In cells A10 and C10, I have two different calculations with a number total for each cell. In B10, I'd like to have a calculation that looks at A10 and C10 . . . if those two numbers are the same or within 1 of each other, B10 is bright yellow. If A10 and C10 are different by more than 1, B10 becomes red.

 

[gaz_chops]

In conditional formatting, use

For yellow
=ABS(A10-C10)<=1

For Red
=ABS(A10-C10)>1

 

[sduttonusa]

Was finally able to get at my spreadsheet . . . formulas worked perfectly. Thank you!

 

[gaz_chops]

You're welcome, thanks for the feedback.