Data validation with Conditional format

[Alisya]

Hi, how do i set conditional format to a List that is validated. So for example if 1-4 is a list in validation, how do i set the colors for each number, so when i choose a number the color would change as too.

Excel Workbook
	A	B
1	1	Orange
2	2	Brown
3	3	Purple
4	4	Red
Sheet2

 

[jeffreybrown]

What version of Excel do you have?

2007+ will accomodate more than 3 conditions, but 2003 only 3.

 

[T. Valko]

Hi, how do i set conditional format to a List that is validated. So for example if 1-4 is a list in validation, how do i set the colors for each number, so when i choose a number the color would change as too.

Excel Workbook
	A	B
1	1	Orange
2	2	Brown
3	3	Purple
4	4	Red
Sheet2

What version of Excel are you using?

In Excel 2003 and earlier you can only have 3 conditional formatting conditions. If you have more than 3 conditions then you need to use a VBA event macro.

In Excel 2007 and later it's basically unlimited.

 

[salahmost]

if Office 2003 :You have 3 conditions plus the original format.
Choose Format then Conditional Formatting then in Condition1:
Cell value is - equal to - 1 press button Format and choose the wanted font and borders and patterns .
Use add for Condition2 and equal to 2 and do as above then add for condition3 ...etc.
if later than 2003 you have more than 3 conditions.

 

[Alisya]

i am using 2003

 

[jeffreybrown]

For more than three conditions you are going to have to consider VBA.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=90

 

[Alisya]

For more than three conditions you are going to have to consider VBA.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=90

Thanks

 

[jeffreybrown]

You're welcome...let us know if you need to further help