troubleshooting Question

Is it possible to add a yes/no box in column that adds current date when selected "yes" and highlights a row of data?

Avatar of cfhasan1
cfhasan1Flag for United States of America asked on
Microsoft ExcelMicrosoft ApplicationsOffice Productivity
5 Comments1 Solution702 ViewsLast Modified:
Condition 1: I want to add a Yes/No checkbox in J3:  EPR CLOSED OUT (YES/NO), and if selected "Yes" it automatically populate I3:ACTUAL CLOSEOUT DATE, with current date.  If J3 is not selected it populates I3 with "N/A".

Condition 2:  If K3:ACTUAL CLOSEOUT DATE  is between date ranges of G3: INITIAL ACA CLOSEOUT & I3:CLOSEOUT          DATE               (CO + 30 DAYS)  highlight Green, If date exceeds specified range highlight record red
EE-Evaluation-Tracker.xlsx
ASKER CERTIFIED SOLUTION
Glenn Ray
US Data Team Lead
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