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.....Download.html and this certainly
helps to increase the number of conditional formatting elements I can have.

Would appreciate your help guys

Try "formula is" option with formula

=EXACT(A1,"T")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525340

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


"Tel" wrote:

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.....Download.html and this certainly
helps to increase the number of conditional formatting elements I can have.

Would appreciate your help guys

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


"Tel" wrote:

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.....Download.html and this certainly
helps to increase the number of conditional formatting elements I can have.

Would appreciate your help guys