Hi there,
I really hope that this is not a repeat of anything already answered a dozen times, but I've genuinely looked on-line for sometime and cannot seem to see a definitive answer to my query regarding colour conditional formatting of dates to reflect the following:
1. If date in cell is less than today then text is RED.
2. If date in cell is equal to or greater than today, but less than 5 days in future, then text is AMBER.
3. If date in cell is equal to or greater than 5 days from today, then text is GREEN
I can usually do one or two of the above, but never seem to get all 3 to work.
Any help would be appreciated.
I really hope that this is not a repeat of anything already answered a dozen times, but I've genuinely looked on-line for sometime and cannot seem to see a definitive answer to my query regarding colour conditional formatting of dates to reflect the following:
1. If date in cell is less than today then text is RED.
2. If date in cell is equal to or greater than today, but less than 5 days in future, then text is AMBER.
3. If date in cell is equal to or greater than 5 days from today, then text is GREEN
I can usually do one or two of the above, but never seem to get all 3 to work.
Any help would be appreciated.