Home

Conditional Formatting Help PLEASE!

L_Fran
Occasional Visitor

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
1 Reply

Hi,

 

In general you don't need Format Painter. Apply rules formula like here to your entire range

image.png

Same is in attached file (for column B only)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies