Calendar Conditional Formatting

Question

I am trying to create a calendar timecard with conditional formatting. I have learned how to apply conditional formatting to an entire ROW based on a cell's value, is there a way to apply conditional formatting to an entire COLUMN based on a single cell's value in that column?

I have tried a few conditional formatting custom equations to no avail.

I would like it to look like this automatically based on conditional formatting.. where the current day is in green and weekends are grayed out:

Answer 1

Assuming you are comparing dates to the first row it would be for example:

=$1:$1=today() (or date you want to compare against)