Previous Topic Next Topic

Mircosoft excel formatting cells complicated

Closed
Gabby - Mar 16, 2010 at 09:08 AM
rizvisa1 Posts 4478 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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses