Hello! So I have tried doing this through conditional formatting but cannot get the cell not to change colour if it is left blank.
Basically what I want is if the value of the cell is todays date or older then red. if within three weeks of the due date then orange and anything longer than this green otherwise if the cell is blank I do not want the colour to change at all.
Any help much appreciated!! thankyou
Basically what I want is if the value of the cell is todays date or older then red. if within three weeks of the due date then orange and anything longer than this green otherwise if the cell is blank I do not want the colour to change at all.
Any help much appreciated!! thankyou