Home > Software design >  Google Sheet Conditional Formating - Color Scale Rows of a table depending of the text
Google Sheet Conditional Formating - Color Scale Rows of a table depending of the text

Time:01-18

I don't find the solution to set a conditional formating with a color scale applied to a range which could be variable from a table to another one. Could you please help me to find the way to do that as in the sheet "Color Scale with Conditional Formating" where I've colored the fields as I would like with conditional formating rules?

Here after the link to the example: enter image description here

And you can add the three rules:

enter image description here

You can add this for the black and white:

=(V3<>"")*(($V3="Cluster 1") ($X3="Total"))

enter image description here

  • Related