Forum Discussion

Moranh's avatar
Moranh
Copper Contributor
Jul 30, 2020
Solved

If condition with text

Hi, I have this column    And I would like to create a condition which will build the below        1) Can I distinguish text with the ; mark?   2) Do I need to create the color c...
excel
Formulas and Functions
  • NikolinoDE's avatar
    NikolinoDE
    Jul 30, 2020

    Moranh 

     

    Here is a small solution ...

    If it corresponds to your ideas as a solution, please mark it as the correct answer, so that other informed can be informed
    ... best with a like. If you did not like the offered solution, please give a short feedback.


    Nikolino
    I know I don't know anything (Socrates)
Moranh's avatar
Moranh
Copper Contributor
Jul 30, 2020

 

NikolinoDE 

Thank you so much! Is there any way to create the headline of the colors automatically? Or I must create them manually? 

TheAntony's avatar
TheAntony
Iron Contributor
Jul 30, 2020

Moranh , Here's a Power Query solution. You can add more values to the blue table on the left and click on Data->Refresh All to update the formatted table. It will automatically pick the colors from the blue table without need for manual entry.

Resources