# Calculation to have cell turn red or yellow

#### sduttonusa

##### New Member
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.

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
In conditional formatting, use

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

For Red
=ABS(A10-C10)>1

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

You're welcome, thanks for the feedback.

Replies
3
Views
139
Replies
7
Views
78
Replies
13
Views
429
Replies
4
Views
331
Replies
2
Views
78

1,203,468
Messages
6,055,597
Members
444,800
Latest member
KarenTheManager

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back