Does anyone have the formula syntax for this.... to control the RYG and Gray symbols on a sheet?
if due date < today and % complete <> 100% then red,
if due date within 5 days of today and % complete <> 100% then yellow,
if due date outside of 5 days from today % complete > 1 and < 100% then green,
if % complete is 0 and due date outside of 5 days from now then gray