Why are my conditional cell/text colours not appearing in the export?

You have to ensure that the value in the cell matches the value you have set up in the conditional colour setting.

In the below example the values of the ‘Progress column are in sentence case but the cell colour settings have been applied to the all caps version of the same words.

To fix, change the values as shown below:

Now your export will show the correct colours.