Overriding conditional format for a handful of specific cells

[Bobbish]

Hi,

I have a workbook, which is nearly totally comprised of copies of one sheet, with different data entered on each.

The sheet has a conditional formatting rule set up so that in certain circumstances it fills the cells in a row in in red.

Unfortunately I find myself needing to recolour a few of these cells on one sheet, to highlight a relationship between them.

Is there an easy way to do this without tinkering with the rule?

Thanks.

 

[Joe4]

Conditional Formatting is going to override any formatting that you try to apply manually. So you need to remove the Conditional Formatting from that cell.
It is pretty quick and easy to do.
Just select that cell, go to Conditional Formatting, select Clear Rules, and then "Clear Rules from Selected Cells".

If you want it even simpler, you can create a really short macro to remove it from the current selection:

Sub DeleteCF()
    Selection.FormatConditions.Delete
End Sub

Then, if you assign a keyboard shortcut to this macro, you can select any cell(s), and use the keyboard shortcut to remove the current conditional formatting of those cells.

 

[Eric W]

You could also add another CF rule, applying to the special cells. Excel allows you to pick the order the rules are applied, and possibly to quit looking at other rules if one already matches. It shouldn't be too hard to add a new rule without interfering with the existing rule. If you want these cells to be constantly highlighted, just set a rule of =TRUE, or if you have a real CF relationship, you can create a real rule.

 

[Bobbish]

Thanks both.