Freezing Conditional Formatting

  • Thread starter Thread starter Ashish Chamaria
  • Start date Start date
A

Ashish Chamaria

Hello,
I am using MS-Office-2000.
I have applied formula-based conditional formatting on a range of cells.
Now, I want to remove the Conditions but wanna keep the formatting on the
data as it is. This will help me in Moving the data around the sheet without
loosing the formatting.
Is there any way of achieving this ?

Thanks,
Ashish
 
Ashish,

I can't think of a direct way to apply a particular format of conditional
formatting to the cells as regular (permanent) formatting. can you use the
same conditional formatting at the destination? Or, instead of using
conditional formatting, you could run a macro that applied normal
formatting. Then it would copy and paste.
 
Actually I had to apply some colour-codes on the data based on certain
conditions. The datasheet that I have contains around 6000 cells of data. So
I created a conditional formatting formula which I copied on all the 6000
cells to get the desired color formatting for different kinds of data. The
conditional formatting formula itself is dynamic as it is not based on any
one particular cell and thats why I cant use absolute referencing in this
formula as it later has also to be applied on all the 6000 cells.

But once the cells have been colored on the basis of conditional formatting,
I want to keep the colours and remove the conditional formatting from the
cells, because now if I MOVE just a part of that data to someplace else in
the sheet, it rechecks for those conditional formatting checks as per the
new location of the data and reformats the data.

Please help.

Thanks
Ashish
 
Hi Dave,
Thanks a lot for your reply.
Its just that I wanted to share a workaround which I discovered for
achieving the task.

Just copy the data (that has been conditionally formatted) and paste it in
MS-Word document. Now, recopy the same data from MS-Word and paste it in
MS-Excel.

The formatting stays but the conditions are gone !!!

Thanks
Ashish
 
Back
Top