Forum Discussion
Mark Vennor
Aug 24, 2017Copper Contributor
Highlighting Columns
Hi, potential easy one here. I've got a spreadsheet with names in the rows on the side and dates along the top columns, used for planning travel dates. I plan 6 months at a time so I'm continually sc...
SergeiBaklan
Aug 25, 2017Diamond Contributor
Hi Mark,
Assuming you have dates in row 1 starting from B1 and till, for example, BZ1, apply conditional formatting rule
=B$1=TODAY()
to your entire range. e.g.
=$B$1:$BZ$1000