Hello,
In Column K I have highlight cell rules for Within 30 Days (green), Within 10 Days (yellow), Within 5 Days (orange), and Past Due (Red).
My formulas aren't working because there aren't any yellow or orange cells. Can someone please help so these work properly?
Also it would be nice to have the total numbers of these if there are any in cells D3:D5 thanks.
Thank you
Bookmarks