Search results

I've now come across another problem and need to use the value created by a formula in the code. How would I refer to this value? Thanks Phil

Thanks, thats made it a lot easier :-)

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...

I don't know if I'm doing something wrong but this code won't do anything! This is exactly what I've got: Private Sub Worksheet_Activate(ByVal Sh As Object, ByVal Target As Range) Select Case Target.Value Case 1 Target.Interior.ColorIndex = 3 Case 2 Target.Interior.ColorIndex = 6 Case 3...

That sounds great. If the range is g5 to g67 where would I add that to the code? Thanks Phil

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...