CODEWITHSUNDEEP
google-sheetsgs-conditional-formatting
Steve
Steve

Reputation: 11

Copying conditional formatting in google sheets

In google sheets is there a way to copy just the conditional format without copying the cell that is being validated? Meaning

I have a value in E2:E37

I want to create a conditional format rule IF E2 < D2 Fill Color Green IF E2 > D2 Fill Color Red

Instead of creating this rule on each cell in E3-E37 I want to copy the rule, however, when I do copy -> paste special -> conditional formatting only It will copy the rule but validate against the cell in which its being copied from.

Apply to range will change from E2:E3 Formula will remain at =D2

Upvotes: 0

Views: 4203

Answers (1)

Torey Price
Torey Price

Reputation: 397

Using the $ sign in front of the letter E and D to anchor just the columns should work. You would use the "custom formula is" option and enter the following formula:

=$E2>$D2 //select green highlighting

and then create an additional rule:

=$D2>$E2 //select red highlighting

You would then copy the cells with the formatting and then highlight the cells below you would like to format and select paste special > paste conditional formatting.

Upvotes: 1

Related Questions