Forum Discussion
How to make whole rows highlighted by date and text?
I'm trying to stay on top of the invoices that I place in my spreadsheet so that whole rows are automatically highlighted once 14 days has passed if they haven't been entered into my accounting softw...
First, delete the existing conditional formatting rule for column C.
Select all the rows that you want to format, not just column C.
Let's say that row 2 is the top row in the selection, and that the active cell in the selection is in row 2.
On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=AND($C2<TODAY()-14,$C2<>"",$K2<>"Entered")
Here, K is the column in which you type "Entered".
Click Format...
Specify the desired formatting, then OK your way out.