troubleshooting Question

Excel Conditional formatting

Avatar of patriotman
patriotman asked on
Microsoft ExcelMicrosoft Office
5 Comments1 Solution18 ViewsLast Modified:
I'm struggling setting up conditional formatting in excel for some reason. This is what I am trying to do:

I would like for columns W – AM to be conditionally formatted to change colors 30 days, 60 days, and 90 days prior to expiration. I would like the cells for dates that will expire 30 days from Today() to be bright red, expiring in 60 days to be bright orange and expiring in 90 days to be bright yellow. If the date is already past and it is expired the cell should be black with white font.

Can you point me in the right direction please?

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros