Conditional Formatting and Percentages of a set target

jamespg@gmail.com

Guest

Posts: n/a

30th Jan 2007

I have to color code several cells depending whether they are on
target or not.

Ex.
100% of Target = Green

90-100% of Target = Yellow

<90% of target = Red

Any help would be much appreciated.

James

« Saving web pages with VB possible? | How to publicly declare a variable? »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting and percentages	Scott	Microsoft Excel Discussion	1	7th Apr 2010 11:36 PM
Conditional Formatting of Percentages	Sherm H.	Microsoft Excel Programming	2	13th Mar 2010 03:58 AM
using percentages in conditional formatting	Rolando	Microsoft Excel Worksheet Functions	1	29th May 2009 12:20 AM
Conditional Formatting with Percentages - only 2 of 3 working	Roady	Microsoft Excel Worksheet Functions	3	16th Mar 2008 11:16 PM
Conditional formatting and calculated percentages	=?Utf-8?B?Tm92aWNlTG9pcw==?=	Microsoft Access Reports	7	29th Mar 2005 06:23 PM