Conditional Formatting

[gofish]

I am using Excel 2003 and it seems to only allow me 3 conditions per row where i am trying to color about 10 cells plus the one with the "X", with 7 different colors from cell a7-g7 containing an "X". If I place an "X" in say, D7, I want cells i7-v7 to change to red. Or if an "X" gets placed in F7, then cells i7-v7 turn blue. But I can only get 3 color changes per line 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?

Would adding a7<>'X' somewhere in this formula =$b$7 = "X" help and where would it go or be written?

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

[shg]

Excel 2003 supports only three conditional formats via the user interface, but you can implement the equivalent of an arbitrary number in VBA.

Excel 2007 supports many more (unlimited?) conditional formats.

[NBVC]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.

http://www.excelforum.com/excel-gene...ting-help.html