No text or picture Add-ons were added yet. How sad!
Hey, welcome back to the Mr. Excel netcast. I am Bill Jelen. Back in episode 907, I talked about how frustrating that is, that here in excel 2007. That color for the selected cells and the unselected cells is practically identical.
Jack, from Boston, who listens to the Podcast on his commute on the train sent in a cool tip. He said “Hey! if you go into properties and go to appearance, go to advanced, there is a setting here called selected items, and you can choose the color for the selected items.” So, let me go into custom colors I will choose color, I’ll have custom colors, click OK. And it takes a second here while windows goes through. All right and sure enough in Excel 2003, that setting actually had an impact. That color becomes the color for the selected cells.
Unfortunately in Excel 2007, they seem to ignore those settings. They are not allowing those settings to come through. So, we still have the same problem in Excel 2007. I am showing this here for those of you in Excel 2003 in earlier who actually would like to change the color of the selected cells. Great tip from Jack! Unfortunately, the Excel team doesn’t seem to respect that setting anymore in Excel 2007. So, we’re still stocked with a very ugly same selection color that we have always had.
Well, I want to thank you for stopping by. We’ll see you next time for another netcast from Mr. Excel.
Transcription by:
Scribe4you Transcription Services