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?