Cell Color changes when specific item is selected in List.

**nukecity83** · 07-12-2009, 07:41 AM

Hi,

What exactly I am looking for is like this I have a list of items some of then are orderable and some are non-orderable (see the attached excel file sheet 2 all orderable have 'Y' flag which I need to validate and those with 'N' should change the cell background color) now on sheet 1 I want a List validation so that even the non-orderable items can be selected but if they are selected the cell color for that specific cell under Product column should change to red.

Let me know if I am not clear with the requirement.

Thanks

**martindwilson** · 07-12-2009, 07:52 AM

define another name for
=Sheet2!$A$2:$A$21 say "yesno"
then use conditional format formula is
=INDEX(yesno,MATCH(A2,Product,0))="n" choose red pattern

**nukecity83** · 07-12-2009, 12:51 PM

Originally Posted by martindwilson

define another name for
=Sheet2!$A$2:$A$21 say "yesno"
then use conditional format formula is
=INDEX(yesno,MATCH(A2,Product,0))="n" choose red pattern

Okay, I got the first point of naming but I dont understand the second one could you put a it in Example sheet attached with the thread 1. I am not able to implement this.

Thanks,