Forum Discussion

L_Fran's avatar
L_Fran
Copper Contributor
Jan 29, 2019

Conditional Formatting Help PLEASE!

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/201812/08/201818/08/2018
14/11/201815/11/201830/11/2018
01/11/201815/11/201818/11/2018
12/11/201810/11/201829/11/2018
14/11/201815/11/201820/11/2018

Resources