ExcelBanter - Conditional Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional Format (https://www.excelbanter.com/excel-discussion-misc-queries/199479-conditional-format.html)

Paul

Conditional Format

I want to format a column but cant copy the formating

eg A1- formula is $B$1

copying the in the A column reverts to B1.

Any answers-using excel 2003

David Biddulph[_2_]

Conditional Format

You may want to look, in Excel help, at the difference between relative and
absolute addressing.
--
David Biddulph

"Paul" wrote in message
...
I want to format a column but cant copy the formating

eg A1- formula is $B$1

copying the in the A column reverts to B1.

Any answers-using excel 2003

All times are GMT +1. The time now is 06:28 AM.