Table Cell Formatting

I have data from a DB going into the Table Component. Under Cell Options>Cell Format I have 4 conditions to change the background color. Specifically, if the value in Column "Weeks until Expiration" <= 1, fill it red, if the value in Column "Weeks until Expiration" <= 2, fill it yellow, and so forth. The red is the highest in the entry list so as to take precedence. After the Table component I take it into Excel Report Writer and then SMTP Mail Writer. What I get as the final spreadsheet in my email is every cell colored red. Even those with a 2. What is the issue? How can I get it to be the correct color? Is there any documentation on this? I'm new to pipeline pilot and I'm struggling to find where resources are.