Forum Discussion

Copper Contributor

Jul 18, 2023

Solved

Formatting auto highlight/fill

Hi

I am trying to set up excel so that Column H (Overdue) auto fills in red if 60 days has passed from Column F (Issue Date) and Column J (Completed Date) is empty. Can someone help me out with this one?

Formulas and Functions

Riny_van_Eekelen
Jul 18, 2023
Becca_70 Create a Conditional Formatting rule with the following formula:

=AND(ISBLANK(J6),F6+60<TODAY())

and apply it to $H$6:$H$398

That should work
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f

2 Replies

Riny_van_Eekelen
Platinum Contributor
Jul 18, 2023
Becca_70 Create a Conditional Formatting rule with the following formula:

=AND(ISBLANK(J6),F6+60<TODAY())

and apply it to $H$6:$H$398

That should work
https://support.microsoft.com/en-us/office/use-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f
- Becca_70
  Copper Contributor
  Jul 18, 2023
  Thanks, that worked a treat 🙂

Resources