Posted to microsoft.public.excel.misc

mpenkala

external usenet poster

Posts: 90

Highlight a max number

hey gang,
easy one here (I'm assuming).

ColAO contains 18 numbers, from AO3-AO20. The numbers change constantly
while I input data. How can I make the current high number change color? I
know it with conditional formatting, but can't seem to get the formula
correct. Also - if 2 or more numbers are currently the highest, both should
be highlighted.

Thanks,
Matt

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Highlight cells with certain number values	Betsy	Excel Worksheet Functions	1	November 26th 07 02:36 PM
Highlight highest / lowest number in a row	[email protected]	Excel Discussion (Misc queries)	3	April 1st 07 02:00 AM
highlight largest number in a row	snmcpa	Excel Worksheet Functions	2	July 17th 06 07:50 PM
How to highlight the smallest number other than zero	Kenny	New Users to Excel	1	January 14th 06 06:41 AM
Highlight lowest number	Amber M	Excel Discussion (Misc queries)	2	January 12th 05 12:19 AM

All times are GMT +1. The time now is 12:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us