I've created a chart that is based on a data set where the cells have
conditional formatting (if value a value b then colour the cell red)

I have the data table displayed with the chart (in chart options, 'show
data table' is ticked), but the condtional formatting is not displayed
in this table, i.e cells that are red in my original data set are not
coloured in the chart table.

Is there any way to apply the conditional format on the table displayed
within the chart?

Cheers

Dan.