Hi,
In the enclosed file I have got so far with Conditional Formatting in a traffic light arrangement, but I have a problem when I am trying to copy the text from column B to column A, all is fine if I use the correct traffic values of -1,0,1 but if I leave a cell blank in column B then col A still sees this cell has a '0' and then enters unwanted text.
Any help appreciated.
Garry
Bookmarks