Insert a new condition before existing conditional formatting conditions

**wotadude** · 05-11-2009, 10:22 PM

Is is possible (via vba) to Insert a new condition before existing conditional formatting conditions.
My existing cells with cond format have max of 2 conditions at present.
Due to the large number of cells/columns involved with varying conditional formatting requirements, i would like to insert a new condition (as condition 1 - as having precedence overs lower existing conds) to each cell in a given row, then i can copt down as required.

The example file attached has -
- cells in row 2 of columns titled data 1, data 2 & data 3 with required result in condition 1 (make black if Action = Ignore).
- cells in row 3 of columns titled data 1, data 2 & data 3 has the an example of an existing condition 1.

Irrespective of existing conditions 1 or 2, is it possible to insert a new condition via vba or add, then re-number the last condition to become the first, and increment other positions to + 1

**se1429** · 05-12-2009, 01:21 AM

Hi,

Try this to add new condition (manually) and then change its position:

Select your cell.
Click Conditional Formatting then click Manage Rules.
When the Rules window opens click New Rule then add your rule.
There are two arrows (top right) that will allow you to change the position of a condition by moving it up or down in the list.

Regards.