Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting Work around?
I have 7 words in a Drop down list which can be chosen for each day of the
Year (a row for each day). I wish to have separate formatting for each of these 7 words. Conditional formatting works great and is exactly what I require, however I am limited only 3 different formats. Is there any way around this? Thanks |
#2
|
|||
|
|||
Hi
only using VBA (an event handling procedure) but no easy workaround "John" wrote: I have 7 words in a Drop down list which can be chosen for each day of the Year (a row for each day). I wish to have separate formatting for each of these 7 words. Conditional formatting works great and is exactly what I require, however I am limited only 3 different formats. Is there any way around this? Thanks |
#3
|
|||
|
|||
In this case, you would have to write a VBA macro that checks the values and
applies the correct format. Typically, you would use an event macro like Worksheet_Change. But in trying to help another user earlier this evening, I learned that the change event isn't triggered when your user selects something from a drop-down (either Data/Validation or a "regular" dropdown). And a Calculate macro didn't fire when I used a formula that referred to the cell linked to the drop-down. On Fri, 29 Oct 2004 07:39:15 +0100, "John" wrote: I have 7 words in a Drop down list which can be chosen for each day of the Year (a row for each day). I wish to have separate formatting for each of these 7 words. Conditional formatting works great and is exactly what I require, however I am limited only 3 different formats. Is there any way around this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |