Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Try this for the red rule:
=AND(ISBLANK(D2),C2<TODAY())
Conditional formatting
![](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)
Anonymous
Hello people who are smarter than me. You're amazing and I need assistance. I want the red box (C2) to not be red if there is a date in the box next to it (D2). I have two rules already and I do not know how to perform the next step. Red (C2) means overdue but if there is anything in D2 then it does not need to be red. Can someone please share your wonderful expertise with me? [the caution box is for the people using the worksheet, it only appears when I unlock the cells so its not an issue]
Microsoft 365 and Office | Excel | For business | Windows
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.
Answer accepted by question author