Color code

Closed
jbsbllcch7 - Jan 26, 2009 at 07:12 PM
identitypc Posts 9 Registration date Wednesday November 12, 2008 Status Member Last seen May 18, 2009 - Jan 27, 2009 at 04:23 AM
Hello,

I have a questionaire, with a yes and no answers. I would like for the cell yes (when clicked on) to highlight blue, and if they hit no the cell would turn red.

any ideas?



Thanks

1 response

identitypc Posts 9 Registration date Wednesday November 12, 2008 Status Member Last seen May 18, 2009
Jan 27, 2009 at 04:23 AM
hi,
try this link to know everything about conditional formatting and how to do it:
http://www.cpearson.com/excel/cformatting.htm
0