Conditional Formatting?


G

Geauxfish

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?
 
Ad

Advertisements

S

Sheeloo

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
 
G

Geauxfish

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?
 
Ad

Advertisements

S

Sheeloo

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top