Change text colour when input cell is less or greater than 1000 to the reference cell

Hi All,

I’m trying to create a formula that will change the input text colour to Red if the input cell value is 1,000 more or 1,000 less than the value of the cell to its left ie;

Cell A1 = 3,200.
If cell B1 is 3,700, do nothing
If cell B1 is 3,000, do nothing
If cell B1 is 4,500, change text to red
If cell B1 is 1,800, change text to red

This then has to work for cell C1 when cell B1 is the reference cell, D1 when C1 is the reference cell......and so on.

What formula can I use?

Teenwolf,

Like Winon said, use conditional formatting. If you're not sure of the process here's a quick overview:

Select "B1" then go to "Conditional Formatting" -> "Highlight Cells Rules" -> "More Rules" -> "Format only cells that contain"

Then select "Cell value" in the first drop down list and "Not between" in the second.

For the first equation use "=A1-1000" and "=A2+1000" for the second.

Select "Format..." and make selections as necessary. Click "OK" and you should be good to go.