Forum Discussion

Mark Vennor's avatar
Mark Vennor
Copper Contributor
Aug 24, 2017

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 scrolling left and right. I'd like to highlight the column and corresponding date each day so it's easier to find. Ie today column BE would be highlighted and tomorrow column BF would be highlighted etc etc...

Any thoughts?

Formulas & Functions
Need Help

1 Reply

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Aug 25, 2017

    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

Resources