Cell Validation on Excel

[bob in calif]

I want to do a cell validation on a worksheet that would come from a table of
Yes or No. I colored the cells in the list to have a Green backround with the
word Yes in the cell and a Red backround with the word No.

My question is there a way for the colors to show up in the cell validation.
Even though the list to chose from is colored cells and bolded. the result on
the cell to be valadated is black and white with a non bolded character.

 

[Bob Phillips]

Wouldn't you just test the Yes or No value?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Per Jessen]

Hi

Have a look at Conditional formatting", it will do what you need.

Regards,

Per

 

[Gord Dibben]

Conditional Formatting with Condition1 equal to "Yes" and Condition2 equal to
"No"


Gord Dibben MS Excel MVP

On Thu, 20 Mar 2008 12:36:00 -0700, bob in calif <bob in