Conditional Formatting Help PLEASE!

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.......


1 Reply



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


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