Pete_UK. THanks!

I tried that before posting, but I must have dome something wrong because I
was getting a circular reference error.

Some follow up questions, but first let me correct my initial question.

In reality, I'm shading M4 red if M40 and L4="x".

I accomplished this using your help by doing the following:
=AND(M40,L4="x")

Follow up questions:
1. L4 is shaded manually, buy I could easily make it a conditional
formatting. If I did that, how could I use that in my formula.

2. Am I correct that if I want all the cells in a column to have the same
conditional formatting (If M50 and L5="x" shade M5 red, and on down the
column), I would have to manually create conditions for each cell? In other
words, am I right that there's no way to copy conditional formatting formulas
for all cells in a column as there is for regular formulae?

3. What I REALLY need is much more complex that this, and I'm not sure if it
can be done. Columns E through L are all shaded different colors (again, I
could easily do that with conditional formatting, but right now it's manual).
What I really want is for a cell in M to adopt the color of whichever of
those columns contains an "x" in the same row. If there is an x in more than
one, I want it to adopt the shading of the right-most column (the highest
lettered column). Is that too complex for conditional formatting to handle?

Thanks again,

jb

"Pete_UK" wrote:

Select E5, bring up the conditional formatting dialogue box and in the
first panel select Formula Is rather than Cell Value Is and then enter
this formula:

=AND(E50,E3="x")

Then click the Format button, Patterns tab and choose Red. OK your way
out.

If E3 is shaded manually rather than through conditional formatting,
then you can't use CF to get E5 to change to the same colour as E3 -
you'd need some VBA to do that.

Hope this helps.

Pete

On Sep 4, 8:25 pm, Nebulous
wrote:
In Excel 2007...

If E50 and E3="x" I want E5 to be shaded red.

How can I accomplish this?

Even better would be:

If E50 and E3="x" I want E5 to be shaded "the same color as E3" (that is,
to use the shaading of E3 as a variable. Doubt that's possible).

Any help is GREATLY appreciated!

jb