'Cumulative' conditional formatting

[Guest]

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

 

[Jon Peltier]

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

 

[Guest]

OK, thanks. When do you reckon one should change?

 

[Jon Peltier]

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