Set the color of a field in Crystal Reports from another field

Hi,

I have Crystal Reports and I am trying to build a report where the color is defined within another file within the database. Here is an example:

I have create a table that contains a color eg:

No when i produce my report I want it to look like this:

How do I go about to achieve this. I know how to do a conditional format in Crystal Reports, but I cannot get it right to do a condition format where the color comes from the database.

Thanks in advance for your assistance.