• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Conditional formatting overwriting table style (sometimes)

In the attached file, when column B evaluates to #N/A a red font is applied, and the underlying table style shows through which is fine.

However, when column B returns a match, a green font is applied, but the underlying table style is overwritten. What is causing this?
 

Attachments

  • Conditional Formatting Overwritting Table Style.xlsx
    14.7 KB · Views: 4
Hello

Iam sure conditional formatting rules for the green font might be conflicting with the table style.
You can try adjusting the order of the conditional formatting rules or modifying their settings to avoid this conflict. This should work
 
Hello

Iam sure conditional formatting rules for the green font might be conflicting with the table style.
You can try adjusting the order of the conditional formatting rules or modifying their settings to avoid this conflict. This should work

I figured it out. I went to the 'Fill' tab under formatting and clicked the 'Clear' button and that worked. Thank you.
 
Back
Top