conditional formating
Formatconditionl formating....

see this website for more info.
http://www.contextures.com/xlCondFormat01.html

-----Original Message-----

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?
action=getinfo&userid=3808
View this thread:
http://www.excelforum.com/showthread...hreadid=314449

.