Search results

Hi I'm trying to use a piece of code to change the colour of a cell depending on the answer from that cells formula. E.g. =a1+b1+c1 in cell d1 If the answer to the formula in d1 is 1 the cell colour needs to be red, if the answer is 2 the colour needs to be yellow and any other numbers green...

Hi I'm trying to change the colour of a cell to red, yellow or green depending on the number inside that cell. If it has a 1 it needs to be red, 2 should be yellow and 3 green. I'm running the code when the sheet is activated. I have been able to write code which lets me do it but there are 32...