Conditional formatting - difference between two cells

[tricityblue]

Hi,

In conditional formatting I'm trying to create a formula to say highlight if the difference between two cells is great than 5000 both ways.

So, I've started =IF(A1="Standard", and this is the part where I need to say the current cell is a difference of 5000 compared to the previous cell.

Any ideas?

Thank you!

 

[Brian from Maui]

Something like

=(A1="Standard")*(ABS(B1-C1)>5000)