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 |
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 |
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 |
All times are GMT +1. The time now is 06:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com