Forum Discussion
Conditional Formatting
I am having trouble with a formula I would like to apply to a date column. I'd like a row to highlight or fill red if the date is past due (Today's Date) AND the cell next to it is "Blank". I would like to have at least the date column fill red when the date is past due =J3<TODAY() AND K4 is Blank. Thanks!
Select the date cells in column J that you want the rule to apply to (e.g., J3:J100)
=AND(J3<TODAY(), ISBLANK(K3))
If column K can contain formulas that return an empty string (""), and you'd still consider that "blank", replace ISBLANK(K3) with:
=AND(J3<TODAY(), K3="")
Hope I was able to help you with this information.
2 Replies
Select the date cells in column J that you want the rule to apply to (e.g., J3:J100)
=AND(J3<TODAY(), ISBLANK(K3))
If column K can contain formulas that return an empty string (""), and you'd still consider that "blank", replace ISBLANK(K3) with:
=AND(J3<TODAY(), K3="")
Hope I was able to help you with this information.
Thank You! I was missing colum K having formulas and considering that "blank".
