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

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

Anonymous ,

How can we identify whether that particular C1H number starts new? Is there any flag column available?

Thank,

Arul

Anonymous's avatar
Anonymous
Not applicable
3 years ago

For example, first number is C1H10014 that number has 4 lines. Then C1H14874 starts. I want the 4 lines with C1H10014 to have a different color than the C1H14874 bc it is another value