Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight numbers above or below predetermined values?
I'd like to highlight numbers below a certain value or above a certain value
in a spreadsheet, thereby drawing my attention to them - help!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight numbers above or below predetermined values?
Use Conditional Formating...Highlight the column you want to apply this
"rule" to. Then click on FORMAT/CONDITIONAL FORMAT. Then you can choose a number of rules, or just one? Up to you. Hope that gets you started. If you get stuck. Write back. -- Sunny FL "Kurt" wrote: I'd like to highlight numbers below a certain value or above a certain value in a spreadsheet, thereby drawing my attention to them - help!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight numbers above or below predetermined values?
Hi,
Select the range of numbers then Format|Conditional Format Cell value is - select greater than - Input a greater than number on the right pick a colour Click OK. Mike "Kurt" wrote: I'd like to highlight numbers below a certain value or above a certain value in a spreadsheet, thereby drawing my attention to them - help!! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight numbers above or below predetermined values?
Conditional Formatting
Kurt wrote: I'd like to highlight numbers below a certain value or above a certain value in a spreadsheet, thereby drawing my attention to them - help!! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight numbers above or below predetermined values
I missed the less than.
Similat to above but this time Formula is enter the formula =AND($A1<"",$A1<2) wher 2 is your lower threshold value Pick another colour Mike "Mike H" wrote: Hi, Select the range of numbers then Format|Conditional Format Cell value is - select greater than - Input a greater than number on the right pick a colour Click OK. Mike "Kurt" wrote: I'd like to highlight numbers below a certain value or above a certain value in a spreadsheet, thereby drawing my attention to them - help!! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I highlight numbers above or below predetermined values?
select your range | go to Format | Conditional Formatting | select 'Cell
Value Is' | in the next drop down select 'Less Than' | in the third box, enter the value or a cell address. Click Add to add more conditions. "Kurt" wrote in message ... I'd like to highlight numbers below a certain value or above a certain value in a spreadsheet, thereby drawing my attention to them - help!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlight Like Values | Excel Worksheet Functions | |||
Highlight cells with certain number values | Excel Worksheet Functions | |||
randomly pick a number from a set of predetermined numbers | Excel Discussion (Misc queries) | |||
Finding a predetermined Sum from a List of Numbers | Excel Discussion (Misc queries) | |||
highlight duplicate numbers | Excel Discussion (Misc queries) |