software

Hi. I'm trying to find on Excel, the thing that allows me to write a
function, so that all the numbers written in a specific area/column (greater
than some number but less than another) come out highlighted. Could you
please email back regarding how to access this quot;greater than or equal toquot;
function? Thank you very much.

greater than or equal to.......gt;=
less than or equal to............lt;=
--
paul
remove nospam for email addy!
quot;ddewdrops522quot; wrote:

gt; Hi. I'm trying to find on Excel, the thing that allows me to write a
gt; function, so that all the numbers written in a specific area/column (greater
gt; than some number but less than another) come out highlighted. Could you
gt; please email back regarding how to access this quot;greater than or equal toquot;
gt; function? Thank you very much.

Sounds like you're looking for Conditional formating, where, for
example, if you wanted the cells in A1:A10 to be bold when their values
are greater than or equal to 5 and less than or equal to 10 you would
do the following:
1) Select A1:A10
2) In the main menu bar..... Formatgt;Conditional formating....
3) Cell Value Is between 5 and 10
4) Click Format... select Bold in the Font style box of the Font tab
5) Click OK, click OK

Note that between 5 and 10 includes 5 and 10 so effect is same as gt;=5
and lt;=10.

Ken Johnson