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:
And you can add the three rules:
You can add this for the black and white:
=(V3<>"")*(($V3="Cluster 1") ($X3="Total"))