Conditional Formatting

[Guest]

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?

 

[Guest]

1. copy the cells into a Word table
2. copy the Word table back into Excel

 

[Guest]

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

 

[David McRitchie]

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

 

[Guest]

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