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