Access 2010 - Linking Excel Worksheets

[BlueHorizon]

Hi all,

I have an Excel worksheet that has color-coded text to represent certain phases of a project, i.e., red, green, blue text.

When I linked this Excel worksheet as a Linked Table, it lost the color coding. The whole reason for trying to link rather than import was to be able to view the colors applied to the text.

Is there any way to keep the colors visible?

Thanks,
KV

Best,
Blue Horizon

 

[dhookom]

No. You would need to create a form and use conditional formatting.

Duane
Hook'D on Access
MS Access MVP

 

[BlueHorizon]

Thank you! I was thinking that was true but wanted to ask an expert.

Best,
KV

Best,
Blue Horizon