help me with this forumla

  • Thread starter Thread starter jladika
  • Start date Start date
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
 
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.
 
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
 
Your welcome, Joe, but note that RagDyer's formula (=d1="y") was even
simpler (and therefore better).
 
Back
Top