This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm in need of formula help for approximately 7 formulas for conditional formatting in Excel please. If there is any way the orange and red fills can be combined.
Scenario: Excel worksheet with multiple workbooks and lots of data used for tracking expirations for certifications, education, and orientation.
Problem: Conditional formatting formulas have worked well for the past couple of years. This year, we've added specific text (NR) before a date in the cell to indicate that the employee has the education/certification but that it's Not Required for their role. I've asked copilot multiple times for help but it's only confused me more and made things worse with my conditional formatting.
Ask: Need cells to automatically change when date has expired and when date is 0 - 30 days from expiration.
Click here for the link to a spreadsheet with my needs.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Can someone help me with the actual formulas please? What I have is not working.
I wouldn't combine text and a date in one cell. Use one column for the dates and another for the text such as NR.