I want to use conditional formatting in an excel document to highlight:
Out of date dates - red
Will expire next calendar month (or in 30 days) - orange
In date - green
I have managed the red and green but the orange doesn't seem to work no what order I put the rules in.
I currently have my dates in format dd-yyyy as a specific date is not really relevant to my data
Any help greatly appreciated!