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

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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"igbert" wrote:

>
> 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

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!

--------------------
(Ms-Exl-Learner)
--------------------


"Luke M" wrote:

> 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.
> --
> Best Regards,
>
> Luke M
> *Remember to click "yes" if this post helped you!*
>
>
> "igbert" wrote:
>
> >
> > 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

Works like magic.

Thanks.

Igbert

"Ms-Exl-Learner" wrote:

> 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!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "Luke M" wrote:
>
> > 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.
> > --
> > Best Regards,
> >
> > Luke M
> > *Remember to click "yes" if this post helped you!*
> >
> >
> > "igbert" wrote:
> >
> > >
> > > 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