Search code examples
google-apps-scriptgoogle-sheetsgoogle-sheets-macros

Is there anyway to highlight and entire column in google sheets based on the value in the top column value?

Is there anyway to highlight and entire column in google sheets based on the value in the top column value?

Currently I have my dates in row 2 that I have highlighted using conditional formatting, but I would like the whole column to be highlighted on the current date.

I am not sure about using a script or macro to change all the column backgrounds.

Any suggestions? Thank you.

Solution

  • Custom Formula: 

    =B2=Today()

    Apply to: 

    B2:B