Color Blind Spreadsheets

While working on our Sox projects I was emailing spreadsheets around. To help track progress I "traffic lighted" certain cells: Green for no problem, yellow when I was waiting for someone, and red when I had to do something myself. I was using Excel 2007, but those receiving my spreadsheets were using Excel 2003. Every time I saved the file, Excel 2007 would wand me about a minor loss of fidelity but I paid little attention. That was until one user complained that there were no green cells on the spreadsheet – only yellow.

Now I must admit to being color deficient (or partially color blind). So when I chose green for the cells, it was a bit of a yellowish green. And when Excell saved my spreadsheet in 2003 format, it changed these green cells to bright yellow! My guess is that the 2007 version of the program uses 24 bit color (like a photo), whereas the 2003 version uses only 8 bit color (like a gif file). And when the 24 bit color was downgraded to 8 bit, the yellow green was changed to bright yellow – totally altering the meaning!

So beware when using Office 2007 and 2003 products in a mixed environment. Things can bite you if you are not careful.