case sensitive conditional formatting

[Guest]

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

 

[daddylonglegs]

Try "formula is" option with formula

=EXACT(A1,"T")

 

[Guest]

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

 

[Guest]

One way is to use the EXACT() function to compare a cell's value to T and to t