Color of shapes from cell content

It looks like your code changes it to the same colour, whether positive or negative. Do you actually want to change it to one colour if positive, and another colour if negative. If so, assuming that negative should be red and positive should be black, try entering the following code in the code module for the sheet (right-click the sheet tab, select 'View Code', copy/paste the code, and Alt+Q)...

Please Login or Register  to view this content.

Hope this helps!