help me with this forumla

[jladika]

=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

 

[DDM]

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.

 

[RagDyer]

Click "Formula Is" and enter this:

=D1="y"

This will work for upper *and* lower case.

Don't understand why the other complicated formula?
--

HTH,

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


=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

joe

 

[jladika]

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

thanks again jo

 

[DDM]

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