I'm working on a data table for finances. I want to highlight the row if the date is in the current week:
What it should look like:
The current condition formatting for the yellow fill spans B5:F15 and is the following:
=(TODAY()-$B6) < 7
The problem is that this ends up coloring the entire table yellow. Why does it do this, and how can I change the conditional formula?
What it actually looks like: