Apply conditional formatting colour scale compared to another column

[hotdogs1999]

Hello,
See below table for referencing. I am trying to apply colour scale conditional formatting (3-colour scale) to column B, dependent on corresponding column A values

Minimum - A is greater than or equal to B (e.g. B4 and B2 would be red)
Midpoint - A is less than B, but no more than 500 less (e.g. B3 would be yellow)
Maximum - A is less than B by more than 500 (e.g. B1 would be green)

How do i do this?

	A	B
1	10000	20000
2	15000	15000
3	34750	35000
4	5500	5000

 

[DanteAmor]

Hi @hotdogs1999
Thanks for posting on MrExcel board.

Use these 3 conditional formats:

Libro2
	A	B
1	10,000.00	20,000.00
2	15,000.00	15,000.00
3	34,750.00	35,000.00
4	5,500.00	5,000.00
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B4	Expression	=A1>=B1	text	NO
B1:B4	Expression	=(B1-A1)<=500	text	NO
B1:B4	Expression	=(B1-A1)>500	text	NO

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​