I have the code below that uses conditional formatting to add a colour to a cell depending on the number that is in the cell. When the number is -3 or below it should turn green but doesn't. When the number is between -3 and 50 it should be amber and over 50 is red. The code only seems to be printing amber and red and ignores the condition for turning the cell green.
Please Login or Register to view this content.
Bookmarks