Auto Identify Values

T

TMc21

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.
 
V

VBA Noob

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
 
R

Ragdyer

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(A1>1,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.
 
Top