Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Add color per value in a column

Hi, i want to add a different color for the whole table based on different values on the values with C1H.  So al lines with C1H014874 should have a different color then the lines with C1H016378.   ...
Need Help
  • Arul's avatar
    Arul
    3 years ago

    Anonymous ,

    try this in conditional formatting

    Thanks,

    Arul

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi arul,

Thanks for your answer. You have done it manually now by filling in the right C1H number. I want that al different C1H numbers have differrent colors, or at least that it becomes very clear when a new C1H number starts.

Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

Anonymous ,

Are you expecting this?

Thanks,

Arul

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    No, all my numbers start with C1H but when a next c1h number starts i want to it to be very clear that is is a other number!

     

     

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User
      3 years ago

      Anonymous ,

      Do you want to show different background colors for all the rows?

      Thanks,

      Arul

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Arul 

         

        I want to have a different background color when a new C1H number starts!