Format Cell Colour
 

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

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

.

Hi!

Conditional formatting
Formula is:

=--MID(A1,MATCH(FALSE,ISERROR(--MID(A1,ROW(INDIRECT
("1:100")),1)),0),100-SUM(--ISERROR(--MID(A1,ROW(INDIRECT
("1:100")),1))))<20

Biff

-----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

.