Format based on result of formula against another sheet

[green biro]

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

 

[Gord Dibben]

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

 

[green biro]

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