Reputation: 37
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
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