help me with this forumla

J

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
 
D

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.
 
R

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
 
D

DDM

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