Currently running 2007, but I must make file 97-03 compatible. I have no
problem in making a cell format conditionally to show a green, yellow or red
depending on its value in older versions because it has an option to ADD
another condition. I cannot seem to figure out how to make additional
formatting conditions in 2007/ Any help appreciated.