need a cell to highlight

  • Thread starter Thread starter jladika
  • Start date Start date
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
 
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
 
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
 
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
 
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
 
Back
Top