need a cell to highlight

J

jladika

can this be done?

when i put somthing in "D3" say a letter "Y"
i would like for "F3" to highlight say a color say " blue"
can that be done??

jo
 
P

Peo Sjoblom

Format>conditional formatting, formula is

=EXACT($D$3,UPPER($D$3)

click format and select pattern, click OK twice

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
J

jladika

=EXACT($D$3,UPPER($D$3)

what does the $ mean?

and will this give the "F3" a color
 
P

Peo Sjoblom

If you select F3 and the do the conditional formatting
dollar signs mean the reference is absolute
Note the exact part is to show for "Y" and not "y" but I forgot the
important thing
use this instead

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

If both lower and upper caps are OK use

=$D$3="y"




--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
J

jladika

I not sure i said this right

in "D3" I have two options "A" or "B"


when i put the " A" in "D3" I want "D4" to turn blue


jo
 
J

jladika

THANKS

Now now in column "C" if i put the option "Y" in any cell

i would like the same cell in column "F" to turn blue
 
Top