Hi everyone,
I have a combo box with the below list inside, I have a single cell that will display the results of whatever I choose in the list I click on, the following formula is in this cell(
) (many thanks go to Andrew R for this formula). The problem i am having is that i want to conditional format the cell that displays the values to white if blank, Green if 0, and red if more than zero, i think the problem i am having here is because of the multiple formats that can be displayed in the cell.
No Of Quarantined Incidents
No Of Units Quarantined
No Of Bins Quarantined
Total Cost Quarantined
Average Units Per Incident
Average Bins Per Incident
Average Cost Per Incident
Thanks you very much for your time and effort.
Bookmarks