Forum Discussion

ErrorPL's avatar
ErrorPL
Frequent Visitor
9 years ago
Solved

Replacing number for Name, but keeping Conditional Formating of table

Hi, For past 2Hour I am struggling with finding a solution for my case. Basically, I want a table with two columns, Expected bin code and ST Status, but I want to replace numbers in cells with text...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago

    Hi ErrorPL,

     

    As you said it's not possible to conditional formatting with text only with number why dont you try to do it with a UNICHAR coding:

     

    Done = SWITCH ( TRUE (), Table1[VALID] = "OK", UNICHAR ( 10004 ), UNICHAR ( 10060 ) )

    This will give you the following result:

     

    Get more Unicode from unicode list.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi ErrorPL,

 

As you said it's not possible to conditional formatting with text only with number why dont you try to do it with a UNICHAR coding:

 

Done = SWITCH ( TRUE (), Table1[VALID] = "OK", UNICHAR ( 10004 ), UNICHAR ( 10060 ) )

This will give you the following result:

 

Get more Unicode from unicode list.

 

Regards,

MFelix

ErrorPL's avatar
ErrorPL
Frequent Visitor
9 years ago

Hi MFelix,

Thanks for your suggestion. I had a look, and it is okey, but not perfect.

 

Do you know if it would be possible to hide number and just leave a cell coloured? I tried in text formatting, but the problem is I can hide one type ( by colouring text to the exact colour of cell), but then other is visible. If this will be possible instead of replacing a number I will be happy with it.

Thank you!