Here is what I am trying to do.
I am trying to make cell colors change if a data source is changed from a different value. The problem is that the data source will never be the same.
For instance if the data source is 5 and you change it to say 4 I want any cells that are linked to the source cell of 5 to change to a different color. But it won’t always be 5.
Anyone got any ideas?
Been messing around with conditional formatting.