Hi,

If the color in E3 is random and can be changed you would need to use VBA to
solve the problem of having E5 shaded like E3. But its possible.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"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