0
I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function.
What I need to do is use this formula in google sheets for conditional formatting.
I would like to highlight any row red where the cell value for that row is BOTH blank in column I AND the date in column D is less than a week away. Separately the functions work, but I can not figure out how to combine these two:
- =$D2
- =ISBLANK($I3)
This worked great, and in google sheets. Thank you! – Jen – 2015-05-27T18:29:48.587
Glad it worked. You can click the check mark to the left to mark it as an answer so people searching know it's been solved. – Engineer Toast – 2015-05-27T20:38:44.507