Forum Discussion

jojo750's avatar
jojo750
Copper Contributor
Apr 15, 2023

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.