Change text color based on other boxes color

[banks]

Hi - i have a table of data, and have put some conditional formatting on the description field. i.e. if description = "impact", the text goes red...

if {FinalReport.description} = "Impact Rating" then
crRed
else if {FinalReport.description} = "Period QPI" then
crRed

Now can i change other boxes that are in the same row, ie i have fireld in the table named period 1 to 13, so need these to change color if the description field does.

Have tried this below but cant get the syntax for looking at description.text

if crred = {FinalReport.description} then
crred
end if

Many thanks, Alex