I am creating a P&L Sheet to evaluate Job Profitability. I want to have two columns where symbols (Red, Green, Yellow, Blue) will show the Job Health. The first column will show symbols based on the Labor Profit Health, and the Second will be based on the Total Project Health.
I would like the colors to meet the following parameters For the Labor Health:
Labor Profit % > 25% - Green
Labor Profit % between 25% and 20% - Yellow
Labor Profit % < 19% - Red (including negative percentage)
Labor Billed = 0 – “Blue”
I would like the colors to meet the following parameters For the Total Project Health:
Total Profit % > 25% - Green
Total Profit % between 25% and 20% - Yellow
Total Profit % < 19% - Red (including negative percentage)
Total Billed = 0 – “Blue”
Any help would be appreciated
