Copy and Paste Conditional Formatting

[igbert]

I have set a conditional formatting for Cell B10

=OR(C10>D10*$G$1,F10>G10*$G$1)

$G$1 is the absolute referece and the other cells are relative reference.

This means the formula for condtional formatting of Cell B11

=OR(C11>D11*$G$1,F11>G11*$G$1)


Is there a way to copy the conditonal formatting up to Cell B2000


Thanks.

Igbert

 

[Luke M]

Copy, Paste Specal - formatting only

or

Select the entire range of cells you want formatted, with cell B10 being
active. Then input your conditional format as you have it written. Format
will be applied to all cells, variable references adjusting accordingly.

 

[Ms-Exl-Learner]

Place the cursor in B10 and extend the selection by holding the shift and
down arrow upto B2000, keep in mind that the active cell should be B10
(Active cell will have a white background after selection also) now goto
format>>conditional formatting>>Formula is>>paste your below formula
=OR(C10>D10*$G$1,F10>G10*$G$1)
Click Format and set your desired formatting and give ok. That's it the
conditional formatting formula is applied for upto B2000 cells.

Remember to Click Yes, if this post helps!

 

[igbert]

Works like magic.

Thanks.

Igbert

Place the cursor in B10 and extend the selection by holding the shift and
down arrow upto B2000, keep in mind that the active cell should be B10
(Active cell will have a white background after selection also) now goto
format>>conditional formatting>>Formula is>>paste your below formula
=OR(C10>D10*$G$1,F10>G10*$G$1)
Click Format and set your desired formatting and give ok. That's it the
conditional formatting formula is applied for upto B2000 cells.

Remember to Click Yes, if this post helps!