96jeremy
96jeremy

Reputation: 7

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.

Upvotes: 0

Views: 4043

Answers (1)

TheMaster
TheMaster

Reputation: 50688

Custom Formula:

=B2=Today()

Apply to:

B2:B

Upvotes: 2

Related Questions