Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Cumulative' conditional formatting
I'd like to use conditional formatting in a 'cumulative' manner, i.e. have
condition 2 (and 3) tested and applied independently of whether condition 1 (or 2) is true. For instance, if both of conditions 1 and 2 are true in the example "if condition 1 is true, cell font should be green" + "if condition 2 is true, cell font should be bold", the cell font should be green bold. It is to a certain extent possible to create large formulae through combinations of the varios conditions to create a set of mutually exclusive situations but a) the formulae quickly get convoluted and b) the 'three conditions only' limit makes this impossible for more complex situations. Thanks in advance Henrik |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Cumulative' conditional formatting
This is available in Excel 2007. To do it in 2003 you need to use more
complicated formulas in the CF dialog, you're limited to only three conditions, and the first condition that is activated stops testing additional conditions. Or you can use VBA. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Henrik" wrote in message ... I'd like to use conditional formatting in a 'cumulative' manner, i.e. have condition 2 (and 3) tested and applied independently of whether condition 1 (or 2) is true. For instance, if both of conditions 1 and 2 are true in the example "if condition 1 is true, cell font should be green" + "if condition 2 is true, cell font should be bold", the cell font should be green bold. It is to a certain extent possible to create large formulae through combinations of the varios conditions to create a set of mutually exclusive situations but a) the formulae quickly get convoluted and b) the 'three conditions only' limit makes this impossible for more complex situations. Thanks in advance Henrik |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Cumulative' conditional formatting
OK, thanks. When do you reckon one should change?
"Jon Peltier" wrote: This is available in Excel 2007. To do it in 2003 you need to use more complicated formulas in the CF dialog, you're limited to only three conditions, and the first condition that is activated stops testing additional conditions. Or you can use VBA. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Henrik" wrote in message ... I'd like to use conditional formatting in a 'cumulative' manner, i.e. have condition 2 (and 3) tested and applied independently of whether condition 1 (or 2) is true. For instance, if both of conditions 1 and 2 are true in the example "if condition 1 is true, cell font should be green" + "if condition 2 is true, cell font should be bold", the cell font should be green bold. It is to a certain extent possible to create large formulae through combinations of the varios conditions to create a set of mutually exclusive situations but a) the formulae quickly get convoluted and b) the 'three conditions only' limit makes this impossible for more complex situations. Thanks in advance Henrik |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
'Cumulative' conditional formatting
You should wait to upgrade at least until you know that all features you
need work properly in the new version. For example, there are a number of charting features which aren't quite right in Excel 2007, so I will wait until I have tested the first service pack. Somewhere on Microsoft's web site, they have a link for downloading a test version. If all you need is the conditional formatting, you might instead look for a VBA solution. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Henrik" wrote in message ... OK, thanks. When do you reckon one should change? "Jon Peltier" wrote: This is available in Excel 2007. To do it in 2003 you need to use more complicated formulas in the CF dialog, you're limited to only three conditions, and the first condition that is activated stops testing additional conditions. Or you can use VBA. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Henrik" wrote in message ... I'd like to use conditional formatting in a 'cumulative' manner, i.e. have condition 2 (and 3) tested and applied independently of whether condition 1 (or 2) is true. For instance, if both of conditions 1 and 2 are true in the example "if condition 1 is true, cell font should be green" + "if condition 2 is true, cell font should be bold", the cell font should be green bold. It is to a certain extent possible to create large formulae through combinations of the varios conditions to create a set of mutually exclusive situations but a) the formulae quickly get convoluted and b) the 'three conditions only' limit makes this impossible for more complex situations. Thanks in advance Henrik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |