Google Sheets Conditional Formatting For a Column

Question

I have a spreadsheet that has dates in row 1 and data in the rows below it. I want to highlight the entire column that has a date that is today, or within the last 7 days.

I've been searching and I keep finding examples of how to highlight a row, but not a column.

Answer 1

Please try selecting all cells and: Format - Conditional formatting..., Custom formula is and:

=and(A$1>today()-7,A$1<today()+1)

with highlighting of your choice. Done.

In this case the row is anchored, I agree more usual to anchor ($) the column.