Conditional format to determine if last character in a cell is anumber or a letter

[Tonso]

I have a spreadsheet where I enter weights. The weights can be any
whole number 1-99999. I would like to be able to flag suspicious
weights using conditional formatting by putting a letter as the last
character, such as 123a, or 57b, 4471c, etc.What conditional
formatting formula can I use to accomplish this?

Thanks,

Tonso

 

[Pete_UK]

Assuming your weights are in column A, starting with A2, highlight the
cells in that column with A2 as the active cell, and use this formula
in the CF dialogue box:

=AND(CODE(UPPER(RIGHT(A2)))>=65,CODE(UPPER(RIGHT(A2)))<=90)

Then click on the Format button and set the format for the cell. When
you OK your way out, XL will apply the conditions to all the
highlighted cells.

Hope this helps.

Pete

 

[Tonso]

Assuming your weights are in column A, starting with A2, highlight the
cells in that column with A2 as the active cell, and use this formula
in the CF dialogue box:

=AND(CODE(UPPER(RIGHT(A2)))>=65,CODE(UPPER(RIGHT(A2)))<=90)

Then click on the Format button and set the format for the cell. When
you OK your way out, XL will apply the conditions to all the
highlighted cells.

Hope this helps.

Pete



- Show quoted text -

Works perfect Pete!! Thank so very much!

Tonso

 

[Pete_UK]

You're welcome, Tonso - thanks for feeding back.

Pete