Excel 2003 Copying Conditional formatting overwrites cell formatting

Mike_500

New Member
Joined
Aug 18, 2010
Messages
2
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
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Derek Brown

Well-known Member
Joined
Dec 26, 2005
Messages
2,390
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).
 

Forum statistics

Threads
1,144,568
Messages
5,725,046
Members
422,590
Latest member
Mikeyyy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top