I haven't tried it yet but is it possible to do an if statement based on colour? I want it to do a specific calculation in the colour is red and a diff one if it is blue etc. ie If the cell is red and the number 5 is in it then do x=10-5 if the cells is blue and the number 5 is in it then do x=20-5 etc. Is this possible?