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 thi...

excel

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

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 🙂

Forum Discussion

Formatting auto highlight/fill

Resources