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

  • jojo750's avatar
    jojo750
    Copper Contributor
    Apr 16, 2023
    Hi Both,
    Thank you, it works but I had complicated the frequency cell with a look up.

Resources