Excel 2003 Copying Conditional formatting overwrites cell formatting

[Mike_500]

I am using Excel 2003. The spreadsheet has formatted columns - some formatted as dates, some formatted as currency, etc.
I want the spreadsheet to highlight in colour any value that is different from the value in the ROW directly below it (i.e. in the same column as it)
I was hoping to do the conditional formatting in one cell and then copy it to the rest of the spreadsheet. That works OK - but the problem is that the non-conditional formatting is copied at the same time. That causes Currency columns to display as dates etc. Is there a way around this?
Thanks

 

[Derek Brown]

Hello and welcome to The Board.
It seems to be available with Excel 2010 which has 'conditional formatting' available on the Paste Special menu.
However, you should be able to do it by selecting all the cells first and then entering the formula for conditional formatting.
For example:
Select cells A2:G10
The first cell selected (A2 in this example) will have no shading and "A2" will appear in the name box (above the heading of column A) - this will be the first cell reference to be entered in the formula.
In the Conditional Formatting diaglog box, enter the formula as:
=A2<>A3
and enter the required formatting etc.
Note that the "A2" in the formula relates to the first cell selected (see above).

 

[Mike_500]

Thanks for the reply