Hot answers tagged conditional-formatting
If my understanding of your task is correct, it cannot be done using the 3-color scale with formulas only. You need to use relative references, which are not acceptable in formulas of the 2/3-color scale and icons set. There are two possible solutions: The one you used. If the 1st tick in each rows should always be red, 2nd orange and so on, then you can ...
Only top voted, non community-wiki answers of a minimum length are eligible