I'm trying to incorporate conditional formatting into a spreadsheet. It
seems the formulas are absolute references. (ie) I want to set up the
condition for cell A1 based on B1, then copy it to the following cells with
A2 referencing B2 and A3 referencing B3. It seems the fomulas are always set
to $A$1. Is there a way to change this?

Just edit the formula to remove the $ symbols
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kevin Harrington" <(E-Mail Removed)> wrote in message
news:0D3B9C65-8B18-4558-A9B5-(E-Mail Removed)...
> I'm trying to incorporate conditional formatting into a spreadsheet. It
> seems the formulas are absolute references. (ie) I want to set up the
> condition for cell A1 based on B1, then copy it to the following cells
> with A2 referencing B2 and A3 referencing B3. It seems the fomulas are
> always set to $A$1. Is there a way to change this?