Hi All, I am trying to do conditional formatting based on a few different dates relative to todays date:
In Col F I have a keyed date with Col G a formula to show a date 6 weeks later. I want to format columns B to N as follows:
Ian
Col B | Col C | Col D | Col E | Col F | Col G | Col H | Col I | Col J | Col K | Col L | Col M | Col N |
02/02/2021 | 16/03/2021 |
In Col F I have a keyed date with Col G a formula to show a date 6 weeks later. I want to format columns B to N as follows:
- No Formatting if no data in any columns
- If any data entered in any column, then format to fill Orange (B to N)
- if date in Col G is within 2 weeks of todays date then format to fill B to N in Yellow
- if date in Col G is same or later than todays date then format to fill B to N in Red
- Over-ride - if I input a 1 in column O then fill all with Green
Ian