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
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