Help please! Formula needed for conditional formatting.

[SLIDE1]

This is what I am trying to do.
A1 and B1 defines a required measurement range that must be met (exp. A1 = .010 / B1 = .020 ).
C1 is the result of a measurement. C1 to turn red if the # entered is above or below the required range and green otherwise.

This much I have accomplished, where I am having issues is getting C1 to accept a letter and # formatting ( exp. .015 R ) without result being red.
Is this possible with a formula or cell formatting??
Any help would be great!

[Lemice]

Hello SLIDE1,

Well, do you have a set of rules on where and how many letters can appear in column C?

If it's only one letter, and always at the end for e.g, you can always use a TRIM(LEFT(C1,1)) for example, to return the number part of it, and then you can put condition on it just like you do on A and B column

[CAntosh]

Lemice has the right idea, you need to separate the numerical and alphabetical components of C1 while crafting your CF rule. Something like this for RED formatting should work:

=OR(LEFT($C1,4)+0>=$B$1,LEFT($C1,4)+0<=$A$1)

[SLIDE1]

Thanks for your quick response Lem and cantosh !
That worked great! One letter is not the only entry that will be entered in the cell but I can experiment with the formula and probably get what I need.
Thanks for your help!

[CAntosh]

Glad we could help! Keep in mind that the formula I offered only looks at the first four characters in C1, so if the numerical portion is longer than that, you may need to modify the "4" in LEFT($C1, 4) accordingly.