Excel conditional formatting cells between columns with changing values

Copper Contributor

Hi Everybody

I m trying to solve this please

I have a column where dates change progressively day by day  column  S (Day62).

The value of this column is estimated by the entry day on a previous column+62. I have created this already works fine. I need to be able to flag up the date of the next column  R ( definite treatment day) if this day is AFTER the date given in Day 62 column. Ideally by changing cell colour.  So practically if i enter 08/12/22 in R2, because this is after 06/12/22 in S2 the cell R2 needs to flag ie by changing to a given colour. So R<S. I have found ways to make it flag on a given date but not on changing dates. Any ideas please?

 SR
1DAY 62Definite Treatment day
206/12/2208/12/22
308/12/2207/12/22
415/12/2206/12/22
562 
 62 
 62 
 62 
 62 
 62 
 62 
 62 
 62 
 62 
 62 
 62 
 62 

 

1 Reply

@Georgedoc A conditional formatting rule like in the picture below would do it. Note that I did this on a Mac, but it works similar on a PC, though the screen looks a bit different.

Screenshot 2022-10-10 at 07.24.12.png

Attaching the file as well so that you can see how it looks on your end.