Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |