Select the cell, then click Insert then Name, then define, then type
in the name you want. If you name cell A1 of sheet2 "test", then you
can type in "test" in a formula, or conditional format condition, or
pretty much anywhere you would previously have had sheet2!a1 and it
will be pretty much the same.



On May 7, 6:11 pm, "Gary" wrote:
Ho do I name a cell?

wrote in message

oups.com...



Gary

You can't base conditional formatting in one worksheet on a value in
another worksheet unless, you are basing it on a named range. If you
give cell A1 in Sheet2 a name, say "test", then apply the following
two conditionsfto the ormat to cell A1 in Sheet1:

=AND(OR($A$1="A",$A$1="B",$A$1="C",$A$1="D"),test= "X")
=AND($A$1="E",test="Y")

I think you should get what you want. You can probably simpify the
one with the OR a little bit.

Good luck.

Ken
Norfolk, Va

On May 7, 5:36 pm, "Gary" wrote:
Hi All,

How do I do the following?

If A1 in Sheet1 = A or B or C or D and A1 in Sheet2 = X then A1 in
Sheet1
should be red. but if A1 in Sheet1 = E and A1 in Sheet2 = Y then A1 in
Sheet1 should be red.

Thanks
Gary- Hide quoted text -

- Show quoted text -