are you working with excel 2007? if yes, then check the box which says 'stop
if true'.

in 2003 that is the default and only option.

you can also add the condition a7<'X' in the second condition and son on
(with an AND

"Geauxfish" wrote:

When I highlight A7, I7-V7 then conditional format with =$A$7 = "X" and it
highlights purple perfectly when an X is placed in cell A7, but I need to
apply the another condition on the same line this way B7, I7-V7 and apply
condition with =$B$7 = "X" to highlight green if cell B7 has an "X". I have
to perform the same condition on line 7 for C7, D7, E7, F7 and G7 with
different colors if an "X" is placed in either one of those cells. If I
apply another condition to B7, it erases or ignores the condition I placed
earlier on A7. Is there an answer?