Hi everyone, I've got a spreadsheet that I use to track customer jobs. I'm constantly adding and modifying data in the spreadsheet. I would like to apply conditional formating for an entire row based off the date in column C. I can create a conditional format based on the date, but it only applies to column C and also applies the formatting to blank cells, which I do not want. What I'm using right now is =TODAY()-C1>30. Any suggestions?
Bookmarks