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...
- Apr 15, 2023
Please see attached workbook.
Patrick2788
Apr 15, 2023Silver Contributor
Please see attached workbook.
- jojo750Apr 15, 2023Copper 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.
- Patrick2788Apr 15, 2023Silver ContributorYou're welcome! Enjoy the weekend.
- jojo750Apr 16, 2023Copper Contributor
HI Patrick,
Can I pick you brain for one more thing...
I am trying to add a formula to calculate the next appointment date based on a previous date but have a frequency column in the middle to dictate time between;
ie; '3' - 3 months (90 days)
'4' - 4 months (120 days)
'6' - 6 months (180 days)
LAST SEEN 01/04/23FREQUENCY 3
NEXT DATE =H3+I3, IF(I3=3, (then +90), I3=4 (then +120), if i3=6 (then +180))
Think this is the last one, actually managed some of the others.