CODEWITHSUNDEEP
google-sheetsautofillgs-conditional-formatting
bopp
bopp

Reputation: 55

Auto-Fill for Conditional Formatting in Google Sheets

I have a Google Sheet with conditional formatting that changes the background color of cell H2 based on the contents of cell F2. I want to auto-fill this conditional formatting rule down the column, so that cell H3 depends on F3, H4 on F4, and so on.

When I drag the cell's formatting down the column (Auto-Fill), the conditional formatting rule doesn't get sequenced - the origin cell's rules just get copied verbatim.

Is there a workaround, besides manually editing the rule for each row?

Upvotes: 2

Views: 6107

Answers (1)

pnuts
pnuts

Reputation: 59460

It would help to have some more details of how you established the rule that you have but Custom formula is of:

=H2=F2

and Range H2 should copy down as you require.

Upvotes: 1

Related Questions