I am trying to highlight today's column -(the header cell)
| Date 1 | Date 2 | Today | Date 4 |
|---|---|---|---|
| - | - | Highlight | - |
| - | - | Highlight | - |
| - | - | Highlight | - |
=A$1=TODAY() is not working
CodePudding user response：
if dates are in row 1 apply to range A1:Z1 this custom formula:
=A$1*1=TODAY()