Is there any way of giving the data in a column a default background color, which can then be overridden by conditional formatting, while not coloring the column header?
I have a mixed column of characters of X, -, and integers
I want all the integers to have one background colour, while the X and the - are two more colours, but the header needs to stay white.
Is there any way of giving the data in a column a default background color, which can then be overridden by conditional formatting, while not coloring the column header?
I have a mixed column of characters of X, -, and integers
I want all the integers to have one background colour, while the X and the - are two more colours, but the header needs to stay white.
Thank you.
Hi Martin
Thank you for reaching out to us.
You can do this only if you add a custom CSS class to all numerical columns, and then define the color with custom CSS.
Then, using conditional formatting you would be able to change that color also.