Copy cell appearance but not conditional formatting

[Snowsride]

I have a spreadsheet with some conditional formatting. How can I cop
the appearance of the cells without the formatting condition

 

[Frank Kabel]

Hi
AFAIK this is not possible

 

[AlfD]

Hi!

I suggest you copy the formatting and then remove the conditiona
formatting.

This latter should be fairly quick, using the Delete button in th
dialogue box.

Al

 

[Snowsride]

Alf

Tried your solution but when the condition is removed the formatting i
lost

 

[AlfD]

Hi!

If the format depends on conditional format: yes it will be lost.
In effect, conditional formatting has no life of its own beyond bein
generated if the condition is fulfilled.

If you want, say, a snapshot which shows the state of the sheet: mayb
a picture?

Al

 

[Dave Peterson]

A couple of not so nice ways:

#1. Take a picture of the range.
Select that range
Shift-edit|Copy Picture
paste into a different application

or within excel
select the range
edit|copy
insert a new sheet????
shift-edit|paste picture

But both those techniques are pretty much impossible for a larger range.

#2. Copy the cells
Paste into MSWord
(send from there???)
or copy and paste back into Excel.
(but all your nice formulas will be gone, but the formatting is still
there.)

#3. An ungawdly macro.
http://groups.google.com/[email protected]
(It's been awhile, but it worked for me back then.)