Format Cell Colour

[scottymelloty]

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

jp10
as9
8
nt17

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

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

All the cells are formatted as text as well

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

Many Thank

 

[Guest]

conditional formating
Format>conditionl formating....

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

 

[Biff]

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