Please help.
I am able to put on a conditional formatting onto one row but when I am trying to use format painter the formulas are not auto changing and for the life of me no matter what I am doing I cannot get it to work and don't really fancy doing it for each one as there are over 500 rows (and growing)
What I am trying to do is if the date in column B is 4 or less days that column A for the box to turn green and if it is over 4 days to turn red. And then if column C is 16 or less days that column B Green and if it is over 16 days to turn red.......
| 09/08/2018 | 12/08/2018 | 18/08/2018 |
| 14/11/2018 | 15/11/2018 | 30/11/2018 |
| 01/11/2018 | 15/11/2018 | 18/11/2018 |
| 12/11/2018 | 10/11/2018 | 29/11/2018 |
| 14/11/2018 | 15/11/2018 | 20/11/2018 |
