Richiep86
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This helped me achieve what i was looking for,
Many thanks,
Many thanks,
If it did, why a "B" grade? There was nothing more to say.
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")