Hello,
I have a table in which the first line is a phase number and it goes from 1 to 4. I would like to have something, that when I change this number a certain range in that row would change colour.
My logic is, if A1="1" then colour in range A1 to A10 is green.
if A1="2" then colour in range A1 to A10 is yellow.
And so on .
How to do it?
Bookmarks