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

  • Thread starter Thread starter Tonso
  • Start date Start date
T

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
 
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
 
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 -
Click to expand...

Works perfect Pete!! Thank so very much!

Tonso
 
Back
Top