Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unableto access "greater than or equal to" Where is it?
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 "greater than or equal to" function? Thank you very much. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unableto access "greater than or equal to" Where is it?
greater than or equal to.......=
less than or equal to............<= -- paul remove nospam for email addy! "ddewdrops522" wrote: 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 "greater than or equal to" function? Thank you very much. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unableto access "greater than or equal to" Where is it?
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..... FormatConditional 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 =5 and <=10. Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot save Project file as MS Access file | Excel Discussion (Misc queries) | |||
Linking Large Access Table into Excel | Links and Linking in Excel | |||
Access Excel Linked Text and Number Issues | Excel Discussion (Misc queries) | |||
Excel and Access talking | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |