Cond. Format - Absolute Reference

[Allen Scott]

I want to copy condidtional formatting over a range of
cells. The condiditonal formatting requires an absolute
cell reference. Is there a way to set the reference to
relative rather than absolute? If so, how?

Any help would be greatly appreciated.

Thanks.

 

[Paul]

I want to copy condidtional formatting over a range of
cells. The condiditonal formatting requires an absolute
cell reference. Is there a way to set the reference to
relative rather than absolute? If so, how?

Any help would be greatly appreciated.

Thanks.

I'm not sure that I follow you. If you always want to refer to cell A1, no
matter which row your formatting is on, type the reference $A$1 (or A$1). If
you want to refer to A1 on row 1, A2 on row 2, etc., then type the reference
A1 (or $A1).
If you just mean that you navigate to cell A1 to enter its reference, it
will initially come up as $A$1, but repeatedly pressing F4 will cycle this
through A$1, $A1, A1..... until you get the one you want.

 

[Bob Phillips]

Allen,

What makes you think that CF needs an absolute reference. I regularly use
relative references, such as
=A1<TODAY()

and so as I copy down, it goes thru A2, A3, etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)