#1   Report Post  
Posted to microsoft.public.excel.misc
katmando
 
Posts: n/a
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.misc
robert111
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cond Formatting & Validation Jonah Excel Discussion (Misc queries) 1 March 9th 06 10:55 PM
memory? Excel Equation Function / Cond. Formatting Dropout nastech Excel Discussion (Misc queries) 2 January 25th 06 04:29 AM
Complex cond. formatting...Pls. Help! Roz Excel Discussion (Misc queries) 1 December 20th 05 07:52 PM
Can I apply Cond. Formatting to a Formula result? SCrowley Excel Worksheet Functions 2 October 31st 05 08:31 PM
difficulty with conditional formatting Deb Excel Discussion (Misc queries) 0 March 23rd 05 06:13 PM


All times are GMT +1. The time now is 09:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"