Learn How to Copy and Paste Conditional Formatting to Another Cell

Learn how to copy and paste conditional formatting rule from one cell to another cell.

[annarmstrong]

Hi, if I have 2 different conditional formatting rules/ requirements for the same cells. When i drag the copy and paste special, it only follows 1 of the rules, is it possible to drag 2 different rules to new cells?

[hartunion]

Very clear and straight to the point - many thanks

[nicholaswhite]

This doesn't work when comparing two values i.e budget versus spend. Google just allows you to drag the formule and it updates, this doesn't.. Ant one worked out how to do it?

[sheldonstclair]

this was great, thank you. saved my hours of work

[bhushanzalavadiya]

Does not work if conditional formatting is done based on 'Formula"

[A.E.Carrillo]

Didnt work when applying conditional formatting formula, (Logical Test: Column B equals zero then format other cell(s) as white).
I need this on each row.

[rajjain]

Please advice which Office Version are you using in a demonstration.

[HASSANGAMINGSHOW]

Wow... that's great. Thanks u very much...

[julioceron]

Quick question. I have a conditional formatting (use a formula to determine cells to format) on cells A1→I1. The formula I use the formula = J1(select the cell) ="Yes". This will change the colors of the cells A1→I1 green whenever cell J1 has the word "Yes" within the cell. Is there a way to copy that conditional format and paste it to the next row so that the next set of cells will do the same except instead of looking at J1 it will look at J2. I want to repeat this process over the next 20 rows without having to enter it.

[dennisslagle]

And if you Double click the paintbrush, you can select specific cells that you want the C.F. to follow.

[ihopno]

Doesn't work. I'm using Excel 2003

[Iyzdor]

What if we want to copy the formatting style.

Like =e3>c3

But we want to copy it to other blocks so that:
When you paste it it will be

=e4>c4
(Instead of e3 and c3

[reginaneeley]

OMG! Thank you so much, that was so easy and simple. You saved me.

[hadimasriat]

i want to copy conditional formatting without rules. for example i just want to copy the colour. is it posibble ? any one knows ? please help

[abdulmajeedalluhimy]

Saved me a lot of time, thank you so much