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