How can you control the borders of a specific cell in Excel?

For example, how can you make each of the 4 borders of the cell for DEPT a different color?

  
TABLE FILE EMPDATA
    SUM
        SALARY
    BY DIV
    BY DEPT
    BY LASTNAME
END

Thank you,

John

This message has been edited. Last edited by: Kerry,

Check this out: Open the fex in Report painter... select you column (or whatever)... options... style... Select Borders... Go to town with it... Oh, BTW, you'll need "ON TABLE SET HTMLCSS ON" as well... I thin it should work... But, my system (Windows Vista) is not openning / downloading Excel files at this time so I cannot fully test it. If not, I'll delete this post...

I had tried using the Report Painter prior to this post, but did not insert the "ON TABLE SET HTMLCSS ON". It worked for HTML, but not for EXl2K

Thank you,

John

Hi JohnB,

You can't have the borders in EXL2K format (perhaps it will come in the 7.9 release)
You have to use EXL97 format or first save the result in HTMTABLE and then use SET HTMLFORMTYPE=XLS.

Hope this help.
Catherine