override conditional formatting color

Hi

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?

Thanks
Richiep86Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Refine the conditional formatting formulas.

For example, if the formula is

=d5<10

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

=AND(d5<10,F5<>"X")
0
 
Richiep86Author Commented:
This helped me achieve what i was looking for,

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

From novice to tech pro — start learning today.