Conditional Formatting to highlight cell if it is blank and previous cell is more than 7 days ago

[nmbell]

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="")

 

[rollis13]

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

As per your conditions the formula should be:

=AND(TODAY()-A3>=7,B3="")