Recognizing signs

K

Ksenija

Hi,

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

aamerrasheed via OfficeKB.com

Hi,
This can be achieved easily using conditional formatting.

Thanks,
 
J

Joel

Either

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

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