Hi,
Instead of changing the font color to suppress display of duplicates try
changing the cell's number format:
Select all the cell you want hidden. Choose Format, Cells, Number tab,
Custom and in the Type box enter ;;; (three semi-colons) In Excel 2007 you
can go one step further - Excel will automatically format duplicates to hide
the data, but you didn't say you were using 2007.
If this helps, please click the Yes button,
cheers,
Shane Devenshire
"John" <jrtwynam[ at ]rogers.com> wrote in message
news:4935ccd1$0$5050$9a6e19ea[ at ]unlimited.newshosting.com...
[Quoted Text] > Hello.
>
> I have a report that I've created in Excel that I'm having trouble
> printing properly. The report has alternating group colours - e.g. the
> first group could be rows 2 through 5, and all these will have a white
> background; the second group could be rows 6 and 7, and these will have a
> grey background; the 3rd group could be rows 8 through 15, and we're back
> to a white background, etc. Within each group, I have "hidden" the
> duplicated fields by making the font colour match the background colour.
> That is, if rows 2, 3, and 4 are in the same group, but the values in
> column "A" are the same for all 3 rows, then cell A2 will have black text
> but cells A3 and A4 will have text matching the background colour.
>
> This prints fine for the groups with the white background, but the groups
> with the grey background have the text visible on the printout in all
> cells, despite the fact that it displays exactly how I want it to on the
> screen.
>
> Does anybody know how to fix this, so that it prints exactly how it
> displays on the screen?
>
> Thanks,
>
> John
|