troubleshooting Question

Conditional Formatting Formulas

Avatar of Terri Cannon
Terri Cannon asked on
Microsoft OfficeMicrosoft ExcelSpreadsheets
7 Comments2 Solutions220 ViewsLast Modified:
I need conditional formatting formulas to apply to whole columns, if possible. I want to have cells that contain an X to change color based on the expiration dates in another cell. Green if within 120-91 days, yellow if within 90-61 days, red if within 60-31 days, black if 30 days and below, all .  All cells that have a date more than 120 days or are blank should remain unformatted.

Example: Column A contain students names, column B contain due dates and columns C-G contain assignments. If a student has not completed the assignment an X would be placed in the cell under that assignment. Once student is within 120 days to the due date color should change to green.

NAME              DUE DATE      ENGLISH    MATH          READING      HISTORY     COMMUNITY SERVICE
JOHN DOE      13-AUG-17            X                              X                                                X
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 2 Answers and 7 Comments.
Join the Community
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 2 Answers and 7 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