Data Tables and Conditional Formatting

[Poody]

I have a spreadsheet that is set up with currency values and negative
currency values display in red text. When charting these values, the data
table is all black text.

Is there a way to get the negative currency values in the data table (under
the chart itself) to display the in red text while still displaying the
positive currency values in black text?

I am running Windows XP and Excel 2003.

Thanks for your help.

Rich