Format based on result of formula against another sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

green biro - 05 Nov 2007 23:35 GMT

I'd like to use conditional formating based upon the value (True or False)
of the equivalent cell in another sheet. Can I do this without resorting to
VBA?

GB

Reply to this Message

Gord Dibben - 06 Nov 2007 00:24 GMT

Name the equivalent cell in the second worksheet and you can use that name.

e.g. Sheet2 A1 has a defined name of "mycell"(no quotes)

In Sheet1 select A1 and Format>CF>Formuls is:

=A1=mycell

Gord Dibben MS Excel MVP

>I'd like to use conditional formating based upon the value (True or False)
>of the equivalent cell in another sheet. Can I do this without resorting to
>VBA?
>
>GB

Reply to this Message

green biro - 06 Nov 2007 20:10 GMT

I see. Thanks.
However, I need to format a whole range of cells in this fashion.
I think I'm going to have to write VBA to allocate two separate ranges,
enumerate through one and set the cell properties of the equivalent cell in
the second. I'll start coding that tomorrow unless there is anyone who has
done this before or can come up with a better idea.

Thanks again for your interst.

GB

> Name the equivalent cell in the second worksheet and you can use that name.
>
[quoted text clipped - 11 lines]
> >
> >GB

Reply to this Message

Rate this thread: