Dear Madam,
In the attached sheet there is formula to highlight overdue day with red color if due date was 21-11-2022 and today is 22-11-2022 but I wanted to highlight overdue by whatever day whether its one day or 1 year if its overdue then should highlight red.
Example today is 22-11-2022 so only 21-11-2022 highlighted and not 19-11-2022, as 19-11-2022 is also a overdue it should be highlighted red.
Also future expected collection within 7 day I wanted to highlight with orange and future collection expected over 7 days should be highlighted as yellow.
Todays expected collection should be green which is working correctly.
Can you please help/advise.
Hi Sarfraz,
Please see the attached file. It comes down to your formula and the order of the formatting rules in the rule manager. As explained in my tutorial on Conditional Formatting with formulas.
Mynda
