Hi, Pete. Just wanted to let you know that I was just today (November 6)
searching for an answer for this issue. I tried the =AND function and it
worked perfectly. Thanks very much!

Lee

"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