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
Aucun commentaire:
Enregistrer un commentaire