Ryno

Posts: n/a

Ranges within Conditional Formatting

Within a cell, thisis basically what I want to do but am having trouble:
if the value is between 95-100 background = green
else if value is between (90-95) or between (100-105) background = yellow
else if value is <90 OR 105) background = red

Any ideas?

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
Conditional formatting in Charts?	Todd	Charts and Charting in Excel	1	January 11th 05 06:32 PM
Print cells that meet conditional formatting criteria	Roundy	Excel Discussion (Misc queries)	1	December 14th 04 12:13 AM
conditional formatting blank cell	TREK5200	Excel Discussion (Misc queries)	1	December 6th 04 02:23 AM
conditional formatting	frank	Excel Discussion (Misc queries)	1	December 2nd 04 09:57 PM
Adding more than three Conditions to 'Conditional Formatting'	David McRitchie	Excel Discussion (Misc queries)	1	November 27th 04 06:03 PM

All times are GMT +1. The time now is 06:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us