override conditional formatting color


I have inhertied a workbook with conditional formatting and i would like to override some of the colours that the conditional formatting sets. After investigation it appears that the conditional formatting takes precidence and i cannot override it.

Does anyone know how i can?

Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

QlemoConnect With a Mentor DeveloperCommented:
Correct, Conditional Formatting takes precedence, so you will have either apply rules to NOT apply formatting, or insert exclude conditions in the existing conditions. In above example you could put a first rule for F5 <> "X" and no formatting, with stop, at top.
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Refine the conditional formatting formulas.

For example, if the formula is


and you wanted column F to have an "X" to override it, then change the formula to:

Richiep86Author Commented:
This helped me achieve what i was looking for,

Many thanks,
If it did, why a "B" grade? There was nothing more to say.
All Courses

From novice to tech pro — start learning today.