Conditional Formatting pasting

[Comfy]

Morning,

Does anyone know a way of copying the results of a CF formula to the actual cell. The only search results I can find are about copying the CF formulas to other cells/ranges.

The reason I'm asking is because I wish to take a snap shot of the cell using a HTML generator but as the cells interior color is FFFFFF and not the FF0000 that I see due to the CF result, the HTML result is not what I would like.

Any ideas?

 

[VoG]

This might help http://www.cpearson.com/excel/CFColors.htm

 

[Comfy]

Thanks VoG, will have a read.

You don't suppose Richard Schollar would mind if I altered the HtmlMaker20101230 for personnal use?

Although I probably won't be able to apply this to it as there is lots to pick through and some that is way above my understanding. I may just create another Sub for pasting the colors etc in place before running the HTML Maker.

But we'll see.

 

[VoG]

You don't suppose Richard Schollar would mind if I altered the HtmlMaker20101230 for personnal use?

You would need to ask Richard