S
Snowsride
I have a spreadsheet with some conditional formatting. How can I cop
the appearance of the cells without the formatting condition
the appearance of the cells without the formatting condition
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
AFAIK this is not possible
AFAIK this is not possible
A
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
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
S
Snowsride
Alf
Tried your solution but when the condition is removed the formatting i
lost
Tried your solution but when the condition is removed the formatting i
lost
A
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
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
D
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.)
#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.)