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?

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?

I don't follow your last part? add a7<'X' where in this formula =$b$7 = "X"?

I am using 2003 and it seems to only allow me 3 conditions per line, or 3
color changes using condition 1 as =$a$7 = "X", condition 2 as =$b$7 = "X",
and condition 3 as =$c$7 = "X". But I need to do D7-G7 the same way with
different colors. These all work great but not enough conditions for 4 more.
Is there another way?

If I had Excel 2007, would I be able to do this much easier?

"Sheeloo" wrote:

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?

in excel 2003 you can not have more than 3 conditions...

2007 does not have this limitation.

by adding the condition i meant something like
=AND($A$7<"X",$B$7="Y")

"Geauxfish" wrote:

I don't follow your last part? add a7<'X' where in this formula =$b$7 = "X"?

I am using 2003 and it seems to only allow me 3 conditions per line, or 3
color changes using condition 1 as =$a$7 = "X", condition 2 as =$b$7 = "X",
and condition 3 as =$c$7 = "X". But I need to do D7-G7 the same way with
different colors. These all work great but not enough conditions for 4 more.
Is there another way?

If I had Excel 2007, would I be able to do this much easier?

"Sheeloo" wrote:

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?