Reputation: 7
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.
Upvotes: 0
Views: 4043