Cond formatting
 

I have a sheet That has cells that are conditionally formated to go
red.
I want to output the sheet to a new workbook with the red cells but not
with the conditonal formatting refrences as the condition the cells need
to meet, will not be outputted to the new sheet

Cheers
C


--
katmando
------------------------------------------------------------------------
katmando's Profile: http://www.excelforum.com/member.php...o&userid=29803
View this thread: http://www.excelforum.com/showthread...hreadid=532571

Cond formatting
 

edit, create copy.

then in new sheet use format painter to remove conditional formatting.


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=532571