Conditional Formatting - preserve format after remove cell values

I have a situation where I need to use conditional formatting to color code a list.  I then need to be able to send this color coded list out to other users but cannot show them the acutal values.  Is there any way to keep the background color of the cells but remove the values?  Possibly copy the formats to another worksheet, but not the values?

Thanks,

S 

If you don't copy the values, the CF will not show the colour.

You would have to extract the CF colour being shown, and set the cell fill colour to that and then copy it. It can be done but it is far from simple.

 Here's a thought.

Let's say your Conditional Format (CF) colors are Red, Yellow and Green. 

1.  Create a new Dummy column next to your dataset

2.  Tag the records that are conditionally formatted Red with an "R" in the Dummy column.

3.  Tag the records that are conditionally formatted Yellow with an "Y" in the Dummy column.

4.  Tag the records that are conditionally formatted Green with an "G" in the Dummy column.

5.  Then create a new conditional formatting on your new dummy column that says turns all R records to Red, Y records to Yellow, and any G records to green. 

At this point, you can remove the values you don't want to show, as the Dummy column provides the basis for your conditional formatting. 

Cheap, but I think it will work.