JABWootton
Board Regular
 Joined
 Dec 16, 2004
 Messages
 94
 Office Version

 2019
 Platform

 Windows
Cell N13 has a formula in which calculates a Date given certain Criteria
Trying to get Cell N13 to change colours according to Date in Cell N13
If Date in Cell N13 is less than Today then it goes Red
If Date in Cell N13 is more than 120 Days Away then it goes Green
If Date in Cell N13 is less than 120 days away then it goes Orange
Can seem to get simple formula to work
Thanks in Anticipation
Trying to get Cell N13 to change colours according to Date in Cell N13
If Date in Cell N13 is less than Today then it goes Red
If Date in Cell N13 is more than 120 Days Away then it goes Green
If Date in Cell N13 is less than 120 days away then it goes Orange
Can seem to get simple formula to work
Thanks in Anticipation