Home

Time range auto fill color

GarryL
Occasional Visitor

I want to highlight cells green with a date range for the past 2 months, yellow for 3 months ago, and red for 4 months ago or longer

1 Reply
Use the Excel's Conditional formatting. Please have a look at the link below and the video on this

https://www.quora.com/How-do-you-autofill-a-cell-with-color-in-Excel-given-that-it-has-text-in-it
https://www.youtube.com/watch?v=PbND-_3Lpi4
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies