Oct 09 2022 03:12 PM - edited Oct 09 2022 03:22 PM
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?
S | R | |
1 | DAY 62 | Definite Treatment day |
2 | 06/12/22 | 08/12/22 |
3 | 08/12/22 | 07/12/22 |
4 | 15/12/22 | 06/12/22 |
5 | 62 | |
62 | ||
62 | ||
62 | ||
62 | ||
62 | ||
62 | ||
62 | ||
62 | ||
62 | ||
62 | ||
62 | ||
62 |
Oct 09 2022 10:27 PM
@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.
Attaching the file as well so that you can see how it looks on your end.