Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional formatting wth more than 3 conditions
1. I have a workbook with data that is linked from other workbooks. In this
final one I have linked the color score (e.g. RED, BLUE, GREEN, YELLOW) which appears with a background of white. I need the background to appear in the color that is linked but conditional formatting permits only 3 conditions. How do I apply the 4th condition. 2. In addition, I have a workbook that based on dates and % complete there is an adjacent cell that is a color coded score. For instance: Cell A1=Sep-05, A2-Sep-30, Cell f2=0% = Result in the case for cell g2 would be green since this task has started. If I had A3=Aug-8, A3=Sep-30, cell f3=0% = result in cell g2 should be RED since it has not started. Again this is more than 4 conditions and I need the g cells to reflect a color. Any assistance on either problem will be appreciated. Sue |
#2
|
|||
|
|||
You can have three conditional formats PLUS the underlying default
format - that's four :-) |
#3
|
|||
|
|||
Hi, thanks for taking the time to respond. I'm not sure I fully understand.
I can set the 3 conditional formats using Blue, Green and Yellow and have the default format in Red or another of the colors if I choose? How do I set the default format (probably a silly question but I ask just the same). Thanks for you assistance "Temp" wrote: You can have three conditional formats PLUS the underlying default format - that's four :-) |
#4
|
|||
|
|||
The default format is the default format - it's the one that's already
there. If you don't like the settings, right click on the cell and select "Format Cells" -- Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy - "Sue" wrote in message ... Hi, thanks for taking the time to respond. I'm not sure I fully understand. I can set the 3 conditional formats using Blue, Green and Yellow and have the default format in Red or another of the colors if I choose? How do I set the default format (probably a silly question but I ask just the same). Thanks for you assistance "Temp" wrote: You can have three conditional formats PLUS the underlying default format - that's four :-) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
More than 3 Conditional Formatting Conditions | Excel Worksheet Functions | |||
Additional Conditions for Conditional Formatting | Excel Worksheet Functions | |||
Conditional formatting: I have five conditions, how to do this? | Excel Discussion (Misc queries) | |||
Conditional Formatting Blank =white.. but 4 conditions | Excel Worksheet Functions | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |