Search code examples
vbaexcelexcel-2007conditional-formatting

VBA - Conditional Formatting with tick mark and x mark


So, I am trying to use these symbols from conditional formatting, but I only need the red x and green tick mark.symbols Is there a way to use only those two with conditional formatting and apply it within my code.

For those that have answered this is what my screen looks like.edit formatting

Thanks


Solution

  • Depending on what you are applying you conditional formatting you could just set both to green then the last one to red as the picture show, when the number is greater equal than 0 is green else red. ( It's the italian excel version but i think that you can understand what i did)

    Conditional Formatting

    No middle simbol