| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Conditional 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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Format order
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. " wrote: 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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Format order
You could open Notepad and paste the formulas there.
Then copy|paste in your new order. (Might save a bit of typing.) wrote: 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. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Format order
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. |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Format order
I haven't used xl2007 enough to know.
Maybe someone else will jump in. wrote: 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. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Format order
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. -- Regards Roger Govier "Dave Peterson" wrote in message ... I haven't used xl2007 enough to know. Maybe someone else will jump in. wrote: 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. -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Conditional Format order
Thanks for jumping in, Roger.
Roger Govier wrote: 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. -- Regards Roger Govier "Dave Peterson" wrote in message ... I haven't used xl2007 enough to know. Maybe someone else will jump in. wrote: 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. -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Format Cells - Number Tab - Custom - Order of Type Window. | Excel Discussion (Misc queries) | |||
| matching values that are not in order with conditional formatting | Excel Worksheet Functions | |||
| format to a desired style and order | Excel Worksheet Functions | |||
| How do I format a column in alpha order? | New Users to Excel | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
Linear Mode
