ExcelBanter - Conditional format

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional format (https://www.excelbanter.com/excel-worksheet-functions/199520-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

Gary''s Student

Conditional format

Drop the $
--
Gary''s Student - gsnu200801

Bob Phillips[_3_]

Conditional format

Try $B1

--
__________________________________
HTH

Bob

"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 09:18 PM.