Posted to microsoft.public.excel.programming

millwalll

external usenet poster

Posts: 31

Range Question

Hi all I have some data that I have sorted then subtotal. Is there way I can
search all cells for the highest number then have the higest number cell
change colour?

Many thanks

I have been trying to think way to do this but not sure what would be best
so want some advice on best option...

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
Range Question / error 1004: method Range of object Worksheet has failed	Paul	Excel Programming	3	April 7th 05 02:56 PM
Range question	mnewnam[_2_]	Excel Programming	0	October 28th 04 07:28 PM
Range question	strataguru[_19_]	Excel Programming	2	September 25th 04 12:57 AM
Range question in VB	rohnds	Excel Programming	3	July 14th 04 09:51 AM
Range.Formula and Range question using Excel Automation	[email protected]	Excel Programming	0	September 19th 03 04:53 AM

All times are GMT +1. The time now is 06:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us