Forum Discussion
jojo750
Apr 15, 2023Copper Contributor
Conditional Formatting Issue
Hi all,
First time post, I am trying to complete a conditional formatting task for the following;
Due date column (which is calculated from a previous cell) but want to colour code as follows;
Red - if date is today or before
Yellow - if date is tomorrow and 30 days after
Green - if date is 31 + days after
Can anyone help please.
Thanks Jo
Please see attached workbook.
- Patrick2788Silver Contributor
- jojo750Copper ContributorThank you so much, it has worked and you have saved me from what would have a been a long winded task for to work it out.
- Patrick2788Silver ContributorYou're welcome! Enjoy the weekend.