I have recently made a macro to check for certain values and color code them if they are greater than a certain amount. The problem is that the cell does not convert to a number unless i double click on the cell to edit. I tried a few different VBA alternatives and nothing worked.
Code:
Snip of cells that wont convert:Please Login or Register to view this content.
Capture.PNG
Bookmarks