I want one cell to look at the cell next to it and if its the same or above the value I want to colour code the cell green, if its within 90% of the value I want to colour code the cell amber and if its lower than 90% I want to colour code it red - how do I do this can you give me the formula?
Solved by B. B. in 16 mins