F
fai.sheng
I have an Excel sheet which contains a table of projects and a section
of empty cells next to it representing months. I have formatted these
"month" cells with different background colors depending on the status
of the projects. After every data row I have inserted an empty row, so
as to keep the "color codes" apart for each project. This, however,
makes sorting the table rather cumbersome.
I have now eliminated the empty rows and decided to add a white
horizontal border, which would give much the same visual effect as
before. However, even though I can choose to format the border to
white, this is not displayed on the screen (borders remain black) and
when I return to the formatting menu, the color choice is set back to
"automatic". It doesn't work for other colors either, black seems to
be the only "acceptable" border color.
I am running Excel 2004 for Mac (v. 11.3) on a PowerBook G4 under OS X
10.4.9
Any helpful comments would be very much appreciated
Thanks,
Fai
of empty cells next to it representing months. I have formatted these
"month" cells with different background colors depending on the status
of the projects. After every data row I have inserted an empty row, so
as to keep the "color codes" apart for each project. This, however,
makes sorting the table rather cumbersome.
I have now eliminated the empty rows and decided to add a white
horizontal border, which would give much the same visual effect as
before. However, even though I can choose to format the border to
white, this is not displayed on the screen (borders remain black) and
when I return to the formatting menu, the color choice is set back to
"automatic". It doesn't work for other colors either, black seems to
be the only "acceptable" border color.
I am running Excel 2004 for Mac (v. 11.3) on a PowerBook G4 under OS X
10.4.9
Any helpful comments would be very much appreciated
Thanks,
Fai