Posted to microsoft.public.excel.programming

Brad K.

external usenet poster

Posts: 41

Conditional Formating

I am looking for suggestions on help with trying to incorporate Conditional
Formatting into some data analysis.
I will have about 5 columns that I will want to try to Conditionally Format
based on the percentile ranking for each piece of data within that column.
Number of rows of data will be variable. I may want to highlight the top 10%
or top 20% but would need to be able to choose the percentile when running
the macro.
Thanks in advance for any thoughts on this.
BradK

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Conditional formating	Ryan	Excel Discussion (Misc queries)	3	August 20th 08 08:17 PM
Conditional Formating	jk9533	Excel Discussion (Misc queries)	2	October 15th 07 06:49 PM
conditional formating	Paul	Excel Discussion (Misc queries)	1	September 21st 06 09:28 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
Conditional Formating	David	Excel Programming	1	June 15th 04 11:33 PM

All times are GMT +1. The time now is 07:11 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us