Hi,
I need a formula to highlight a cells in a column based on the difference between two other cells from columns B and D.
E.g. I want it to highlight a cell Green if the difference is 0, Yellow if the difference is 1, Red if the difference is 2 and Blue is the difference is more than 2.
conditional formatting2.xlsx
I have tried using this code but because I am not very good with excel, I am struggling to make it work.
e.g. Highlight green if
=MAX(b1,d1)-MIN(b1,d1)=2
What code do I put in the box please?
Joanne
Bookmarks