help me with this forumla

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jladika - 09 Jun 2004 19:54 GMT

=AND($D$3="Y",EXACT($D$3,UPPER($D$3)))

I would like to be able to put a "y" in any cell in column "D"

and have the same cell in column "E" turn blue

can you help me set this up

thanks

jo

--
Message posted from http://www.ExcelForum.com

Reply to this Message

DDM - 09 Jun 2004 21:25 GMT

Joe, this simpler formula worked fine for me:

=OR(D1="y",D1="Y")

I selected Column E (just click the column heading), then Format >
Conditional Formatting. Formula is: =OR(D1="y",D1="Y"). Then I set up the
format.

Signature

DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

> =AND($D$3="Y",EXACT($D$3,UPPER($D$3)))
>
[quoted text clipped - 10 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message

RagDyer - 09 Jun 2004 21:32 GMT

Click "Formula Is" and enter this:

=D1="y"

This will work for upper *and* lower case.

Don't understand why the other complicated formula?

Signature

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Reply to this Message

jladika - 09 Jun 2004 22:52 GMT

Thanks to you DDM
for the help and yes it was so much better.

thanks again jo

--
Message posted from http://www.ExcelForum.com

Reply to this Message

DDM - 10 Jun 2004 13:22 GMT

Your welcome, Joe, but note that RagDyer's formula (=d1="y") was even
simpler (and therefore better).

Signature

DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com

> Thanks to you DDM
> for the help and yes it was so much better.
[quoted text clipped - 3 lines]
> ---
> Message posted from http://www.ExcelForum.com/

Reply to this Message