Autofil color to a row from dropdown list choices
I am trying to autofil certain colors to rows that have dropdown choices.
Each choice will be assigned a certain color. |
Alesia
That would depend upon how many choices you have. Conditional Formatting will give you 3 choices(4 if you count the default) although JE McGimpsey has a method to give 6 if you are entering numerics. For more you could use event code. The drop-downs you could create using Data Validation. Post back with more details. I'm sure we can get you sorted. Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:51:04 -0800, Alesia wrote: I am trying to autofil certain colors to rows that have dropdown choices. Each choice will be assigned a certain color. |
All times are GMT +1. The time now is 02:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com