Hello,
I am trying to find a way to identify numbers from a list that fall into a
certain criteria automatically. I have a list of 100+ securities and am
looking at certain changes in key stats on a month by month basis. Is there
any comman/macro that would say for instance highlight all the values in a
column greater than 1 and less than negative 1? Any help would be greatly
appreciated.

Have you tried Conditional Formatting.

Select sheet or area

Format Conditional Formatting

Put in your conditions (Up to 3) Cell value and format cell as
required

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562570

What you want is "Conditional Formatting".

Check it out in the Help files.

For your example, select the column of data, say A1 to A100, then:
<Format <Conditional Formatting
Change "Cell Value Is" to "Formula Is",
And enter this formula:

=OR(A11,A1<-1)

Then, click on "Format" and choose font and /or cell color and/or borders,
or whatever you wish to bring notice to those cells meeting your criteria.
Then <OK <OK out.

Since you selected A1 to A100,
And the formula contains relative references,
It will pertain to all the cells in the selection.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"TMc21" wrote in message
...
Hello,
I am trying to find a way to identify numbers from a list that fall into a
certain criteria automatically. I have a list of 100+ securities and am
looking at certain changes in key stats on a month by month basis. Is
there
any comman/macro that would say for instance highlight all the values in a
column greater than 1 and less than negative 1? Any help would be greatly
appreciated.

That worked perfect, thank you.

"VBA Noob" wrote:


Have you tried Conditional Formatting.

Select sheet or area

Format Conditional Formatting

Put in your conditions (Up to 3) Cell value and format cell as
required

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=562570