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
wrote:

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.