Mircosoft excel formatting cells complicated

Closed
Gabby - Mar 16, 2010 at 09:08 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 16, 2010 at 10:32 AM
Hello,
i need to change the color of certain cells based on percentage. for example if i have 20 trucks but 6 break down then i have 14 remaining. So i need a percentage of how many trucks are working. But i need to change it to a different color if it is between 100% and 75% to red, 74% to 60% to green, and so on. But i dont want it to change into percentage

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Mar 16, 2010 at 10:32 AM
You need to use conditional formatting

Let say total trucks are in A1
and working trucks are in B1 and this is the cell you want to change color
then choose conditional formating and enter this formula
=(1-(A1-B1)/A1)>=0.75
click on format and change color
0