'Cumulative' conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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
 
Back
Top