LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Recognizing signs

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??
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Recognizing Ctl or shift key in VBA Rhythm Excel Programming 2 October 7th 08 11:33 PM
Recognizing data george Excel Worksheet Functions 1 March 5th 08 10:28 AM
recognizing names vegetassj3 Excel Programming 3 March 17th 06 07:21 PM
Recognizing #N/A nebb Excel Worksheet Functions 1 October 19th 05 12:56 AM
Not recognizing a Const Dan T[_3_] Excel Programming 7 July 18th 04 12:45 AM


All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"