I have data in rows that contain letters as well as numbers, some data
is just numbers, i want to format a cell with a red background if the
cell has a value below 20 so any of these would count and be coloured
in automatically,

jp10
as9
8
nt17

this is obviously easy with just numbers in but the letters before the
numbers is throwing me

the data could be between j1 and j150, as1 - as150, nt1-nt150 and just
1-150

All the cells are formatted as text as well

Any ideas on how i can go about this without manually having to click
each cell and colour it.

Many Thanks


--
scottymelloty
------------------------------------------------------------------------
scottymelloty's Profile: http://www.excelforum.com/member.php...fo&userid=3808
View this thread: http://www.excelforum.com/showthread...hreadid=314449