Hi again,

I have a lots of cells with different values in them. Mostly it is just
numbers, but sometimes I have <0.30 for example. I am writing a macro in VB,
and I want the cells where the value starts with < to change colour. My
problem is that I cant figure out how to write the program so it can choose
cells where the value starts with <.

How should I do it??

I got the answer to do like this:
Either

if left(Range("A1"),1) = "<" then

or
Mystring = "<ABC"
if Left(MyString,1) = "<" then


but I am very new at this so I can't make it work anyway.. I want it to
look through cells say A1:AA200..