Forum Discussion

jojo750's avatar
jojo750
Copper Contributor
Apr 15, 2023
Solved

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...
excel
jojo750's avatar
jojo750
Copper Contributor
Apr 15, 2023
Thank 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.
  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Apr 15, 2023
    You're welcome! Enjoy the weekend.
    • jojo750's avatar
      jojo750
      Copper Contributor
      Apr 16, 2023

      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/23

      FREQUENCY   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.

      • Patrick2788's avatar
        Patrick2788
        Silver Contributor
        Apr 16, 2023

        jojo750 

        I'd go with HansVogelaar 's solution for this one.  Your data is arranged perfectly for EDATE.

Resources