LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Changing rules in mass quantities

Hello there,
I am updating a workbook that has a massive amount of cells with many
conditional formats. To make our sheets more printer friendly, I am having
to go through all of the "formula to determine which cells to format" rules
and changing the fill color one by one. Is there a way to select all of the
rules with this format and change the color all at once? If not, is there an
easier way to go about doing it then just changing them all one by one?
Thanks!
 
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
Mass Changing whole sheets individual cell references Ryan Excel Discussion (Misc queries) 2 January 16th 09 03:59 PM
getting quantities according to date [email protected] Excel Discussion (Misc queries) 0 December 4th 06 10:16 AM
how do I set up a validation rules with two data rules Trudy Excel Worksheet Functions 1 October 16th 06 05:42 AM
Changing default or hidden rules within microsoft excel? Jade Excel Discussion (Misc queries) 1 February 9th 06 11:33 PM
Changing default or hidden rules within microsoft excel? Jade Excel Discussion (Misc queries) 0 February 9th 06 11:28 PM


All times are GMT +1. The time now is 12:35 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"