LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default maxing out conditional formatting

I am trying to conditional format a sheet.

There 5 different formats I would like to use:

Red fill with black text
Red fill with bold blue text
Yellow fill with black text
Yellow fill with bold blue text
No fill with black text

The formatting depends on three things:
1. file status, ie "DUE", "SIGNATURES", "REVISIONS"
2. user(ie, clinician or administrator)
3. due date

Is this too much for conditional formatting given that there are a max of
three. I know that you can have a max of 4 if you use the default, but I
haven't even worked out how to achieve that yet. Possible because I don't
have the formatting in the right order- I know that that affects things. Are
there any guidelines for how to order the conditional formatting?


 
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
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 3 January 20th 07 02:02 PM
conditional Formatting based on cell formatting Totom Excel Worksheet Functions 0 January 15th 07 04:35 PM
conditional formatting hobscons Excel Discussion (Misc queries) 3 October 26th 06 01:08 PM
Conditional Formatting that will display conditional data BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM


All times are GMT +1. The time now is 04:59 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"