Color coding of calculated fields based on value of another field

What is the challenge?

What is the impact?

Describe your idea

I would like to take a value from a calculated field (like days left to due date) and change that field Red if the days left are <90 days and feature status field is <50%, days left are <60 days and features status is <75%, and days left are <30 days and features status is <90%