LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 249
Default Conditional Formatting - 6 conditions

Hi,

Conditional formatting allows for 3 conditions.

I require 6 for the following ranges of data in a field spannin A1 to G50

0-0.1 pale yellow
0.1-0.25 yellow
0.25-1.0 pale orange
1.0-1.5 orange
1.5-2.0 pale red
2.0 red


I guess an IF, THEN statement might work?

Can anyone help?

Thanks,

Roger
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How to use 2 conditions in conditional formatting Asoka Walpitagama - Brandix College IT Excel Discussion (Misc queries) 1 November 12th 09 06:41 AM
Conditional Formatting - more than 3 conditions LinLin Excel Discussion (Misc queries) 4 January 19th 09 10:05 PM
Conditional formatting - with 2 conditions Forum freak \(at work\) Excel Discussion (Misc queries) 2 October 24th 08 05:00 PM
Conditional formatting should allow more than three conditions. Joshua, Technical Editor Excel Discussion (Misc queries) 1 July 26th 06 12:44 PM
Conditional Formatting with more than 3 conditions terrapinie Excel Programming 6 January 27th 05 04:03 PM


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"