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.

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

Tx Rick.....On older versions I could point to a 3 cell area containing 51
53 55 and be able write a rule for =55 is green, =53 is yellow and < 53 is
red. Now using the same logic on 07 does not go green when the cell value
is 55. I must be 55 to make it green. Logic is identical. I have
hundreds to do and use the same column but a different row. Each row has a
different value to compare to. Hate to admit it now, but I have been saving
the file and conditional format it on the older version, and then copy it
back to 07. Spinning my wheels.....:0(


"Rick Rothstein (MVP - VB)" wrote in
message ...
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