LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dana Zulager
 
Posts: n/a
Default copy conditional format as ACTUAL format

i'd like to figure out how i can copy a group of cells that have a
conditional format (stoplight style ... color pattern highlighted for a
certain condition) and paste special only the format, but not keep the
conditional format rules.

one time that it is necessary is if i have an analysis spreadsheet with all
my rules and formulas and internals, but i produce an "output" spreadsheet
that only shows values, widths and formats. the conditional format for a
particular column depends on the values of a column which i don't even
include in the output sheet, so the conditional formatting rules don't work
as designed once transformed to the "output" sheet.

hopefully this question makes sense! thanks for any tips, pointers, ideas.
 
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
conditional format of data tables in charts [email protected] Charts and Charting in Excel 2 January 25th 05 03:56 PM
Problem with Conditional format deletion [email protected] Excel Discussion (Misc queries) 3 December 13th 04 05:10 PM
deleting a conditional format [email protected] Excel Discussion (Misc queries) 4 December 7th 04 10:45 PM
make a conditional format the default Fred Evans Excel Discussion (Misc queries) 3 December 6th 04 05:01 AM
Conditional format rexmann Excel Discussion (Misc queries) 4 December 2nd 04 12:01 PM


All times are GMT +1. The time now is 12:00 PM.

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"