 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Conditional Format order
Hi all, Is there an easy way of changing the order of the three conditional formats for a cell, or do I just have to re-type them all? Thanks - Dave. Sorry, no quick and easy way - just be glad there aren't more to deal with! Do remember that you can change groups of cells to same conditions, at least you don't have to do that one at a time. > Hi all, > Is there an easy way of changing the order of the three conditional > formats for a cell, or do I just have to re-type them all? > Thanks - Dave. You could open Notepad and paste the formulas there. Then copy|paste in your new order. (Might save a bit of typing.) > Hi all, > Is there an easy way of changing the order of the three conditional > formats for a cell, or do I just have to re-type them all? > Thanks - Dave.  SignatureDave Peterson Yeah, thanks. That is easier than re-typing. By the way, I use Excel 2003. Do later versions allow easy chage of conditional format order? Dave. I haven't used xl2007 enough to know. Maybe someone else will jump in. > Yeah, thanks. That is easier than re-typing. By the way, I use Excel > 2003. Do later versions allow easy chage of conditional format order? > Dave. SignatureDave Peterson Yes, In XL2007 you can change the order. Highlight the formula for the Conditional Format, and adjacent to the options to Edit, Delete etc are 2 arrows pointing Up or Down. Use these to move the conditions to whatever order is required. SignatureRegards Roger Govier >I haven't used xl2007 enough to know. > [quoted text clipped - 3 lines] >> 2003. Do later versions allow easy chage of conditional format order? >> Dave. Thanks for jumping in, Roger. > Yes, In XL2007 you can change the order. > Highlight the formula for the Conditional Format, and adjacent to the [quoted text clipped - 17 lines] > > > > Dave Peterson SignatureDave Peterson
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.