Gábor Szegedi
Gábor Szegedi

Reputation: 37

Google Sheets Conditional formatting autofill?

I have the following conditional formatting

=EQ(VALUE(RIGHT(Y2;1));ISOWEEKNUM(NOW())

I want to be able to auto fill this formatting to the other columns so the 'Z' column formula would look like this:

=EQ(VALUE(RIGHT(Z2;1));ISOWEEKNUM(NOW())

Upvotes: 0

Views: 137

Answers (1)

Mike Steelson
Mike Steelson

Reputation: 15318

Autofill is not necessary for conditional formatting. You just need to change the area where the formula will apply (this formula is available for the top left cell and will automatically apply to all others in the area)

Upvotes: 2

Related Questions