lundi 17 février 2020

Conditional formatting a whole column based on the value of another column

I would like to apply conditional formating to all of my column D. If Column D is < or > than the value in F by 150 (in the same row), I want it to highlight red. If the value of D is within the 150 above of below of the value in F then I want it to highlight green.

For example; D2 (360) is more than 150 more than F2 (88), so I want it to highlight red. D10 (200) if within the 150 more or less range than F10 (275) so I want it to highlight green.

Please help and I will attach a picture. Thanks

enter image description here

Aucun commentaire:

Enregistrer un commentaire