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: 138
Reputation: 15328
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