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.

It looks like you just select "New Rule" from the Conditional Formatting
drop-down menu. It might be easier to follow if you select Manage Rules from
that same menu... from this dialog box you can add via New Rule or edit an
existing rule or delete a rule.

Rick