Is there a way to make a conditional format permanent so it keeps the format
generated by the condition regardless if the condition is still met. Sort of
like paste special values?

1. copy the cells into a Word table
2. copy the Word table back into Excel
--
Gary''s Student - gsnu200738


"Dwight_k_Shrute" wrote:

Is there a way to make a conditional format permanent so it keeps the format
generated by the condition regardless if the condition is still met. Sort of
like paste special values?

Tried this but the area i need to copy is very large and it's not really
working.

"Gary''s Student" wrote:

1. copy the cells into a Word table
2. copy the Word table back into Excel
--
Gary''s Student - gsnu200738


"Dwight_k_Shrute" wrote:

Is there a way to make a conditional format permanent so it keeps the format
generated by the condition regardless if the condition is still met. Sort of
like paste special values?

Hi Dwight,

Don't think that the size would matter much in the time for pasting
into Word and back, if it works, but with round tripping code you
could be making things much larger -- you might want to check
the size of your workbook when you are doing such things,
including other suggestions.

Have you considered simply making a copy within Excel and
not changing the copy.

I have setup my Excel to HTML conversion to include coloring
from Conditional Formatting. Keep in mind that C.F. overrides
normal cell formatting, so when finished formatting Excel cells
you would eliminate C.F. altogether -- assume that is your intent.
Should be simple applying the change to the cell rather than
generating an HTML cell.
http://www.mvps.org/dmcritchie/excel/xl2html.htm
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Dwight_k_Shrute" wrote in message
...
Tried this but the area i need to copy is very large and it's not really
working.

"Gary''s Student" wrote:

1. copy the cells into a Word table
2. copy the Word table back into Excel
--
Gary''s Student - gsnu200738


"Dwight_k_Shrute" wrote:

Is there a way to make a conditional format permanent so it keeps the
format
generated by the condition regardless if the condition is still met.
Sort of
like paste special values?

Hi,

More information, please refer to the following url:

http;//www.xldynamic.com/Source/xld.CF.html
http://www.contextures.com/xlcondFormat01.html

Challa Prabhu

"Dwight_k_Shrute" wrote:

Is there a way to make a conditional format permanent so it keeps the format
generated by the condition regardless if the condition is still met. Sort of
like paste special values?