Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 11th 05, 12:56 AM
Danzguy
 
Posts: n/a
Default Conditional formatting: I have five conditions, how to do this?

I'm trying to set up conditional formatting in a worksheet but Excel supports
only three conditions. Does anyone know how to accomplish this? BTW - three
of my conditions result in the same color, if that helps. Thanx for your
consideration!

  #2   Report Post  
Old May 11th 05, 04:02 AM
JE McGimpsey
 
Posts: n/a
Default

You can use VBA - search the archives:

http://google.com/advanced_group_sea...ugroup=*excel*

or look at David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/condfmt.htm#extend

or, perhaps, you can get away with using a mix of conditional and Custom
formatting:

http://www.mcgimpsey.com/excel/conditional6.html


In article ,
"Danzguy" wrote:

I'm trying to set up conditional formatting in a worksheet but Excel supports
only three conditions. Does anyone know how to accomplish this? BTW - three
of my conditions result in the same color, if that helps. Thanx for your
consideration!

  #3   Report Post  
Old May 11th 05, 08:21 AM
Neil
 
Posts: n/a
Default

If you have only five possible conditions, and three of those reult in the
same colour then you could set the format of the cell to default to the
colour that is caused by the three 'common' conditions, then use conditional
formatting to change if for just the other two conditions

HTH

Neil
www.nwarwick.co.uk

"Danzguy" wrote:

I'm trying to set up conditional formatting in a worksheet but Excel supports
only three conditions. Does anyone know how to accomplish this? BTW - three
of my conditions result in the same color, if that helps. Thanx for your
consideration!



Reply
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
More than 3 Conditional Formatting Conditions Beth H Excel Worksheet Functions 12 January 6th 06 07:35 PM
Conditional Formatting is limited to 3 conditions, any way I can . Fred Stoll Excel Worksheet Functions 1 February 11th 05 12:22 AM
Conditional Formatting Blank =white.. but 4 conditions Junior Excel Worksheet Functions 3 December 18th 04 08:32 AM
Adding more than three Conditions to 'Conditional Formatting' David McRitchie Excel Discussion (Misc queries) 1 November 27th 04 06:03 PM
Extend conditional formatting to more than 3 conditions Danny Excel Worksheet Functions 1 November 10th 04 10:57 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017