case sensitive conditional formatting

T

Tel

I am looking for a way to change the conditional formatting dependent upon case

i.e. "T" = white text on royal blue background; however
"t" = Blue text on a light blue background

I have downloaded CFPlus Extended conditional formatting from
http://www.xldynamic.com/source/xld.CFPlus.Download.html and this certainly
helps to increase the number of conditional formatting elements I can have.

Would appreciate your help guys
 
R

Ron Coderre

Try this:

Select cell A1
<Format><Conditional Formatting>
Cells formula is: =EXACT(A1,"T")

(then set the forma)
Repeat using: =EXACT(A1,"t")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top