How do I highlight numbers above or below predetermined values?

's Computer Specifications

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!!

's Computer Specifications

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!!

's Computer Specifications

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!!

's Computer Specifications

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!!

's Computer Specifications

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!!

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:C1F48D07-D62C-4384-BAA5-(E-Mail Removed)...
> 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!!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to get the numbers above and below a number	Raz	Microsoft Excel Worksheet Functions	10	2nd Mar 2009 07:55 PM
randomly pick a number from a set of predetermined numbers	=?Utf-8?B?UmFt?=	Microsoft Excel Misc	6	11th Sep 2007 09:49 PM
Finding a predetermined Sum from a List of Numbers	zach@zachshuford.com	Microsoft Excel Misc	5	17th Jan 2007 01:11 AM
placing even page numbers on predetermined odd pages.	=?Utf-8?B?bGluZHNleQ==?=	Microsoft Word Document Management	2	13th Oct 2004 11:23 PM
ranking a list of numbers above or below the average	Debbie	Microsoft Excel Worksheet Functions	1	10th Mar 2004 05:21 PM