Hi there, please consider me to be a technical dullard but I am doing my best. I have created two columns making calculations based on two other columns. I then have a further column generating a numerical score based on said calculations. Does anybody know how I can change the colour of the box according to the value (say 10 - Red, 6 = Orange, 3 = Green). Any help will be humbly accepted.
See if you can achieve your goal using the Conditional Coloring feature
Perfick. Thank you so much.
One more question: How can I calculate if a value is between two values: Say is it any value between 7 & 15?