Conditional formatting 2007

M

Meebers

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.
 
R

Rick Rothstein \(MVP - VB\)

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.
Click to expand...

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
 
M

Meebers

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(
 
Top