Hello. I am trying to put in a formula to highlight cells in column B if the date in column A is more than 7 days prior to today AND cell B is empty. Any help would be appreciated. I tried the following but it is highlighting cells in column C that have info in them not the blank cells.
=AND(TODAY()-B3>=7,C3="")
=AND(TODAY()-B3>=7,C3="")