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
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
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:
- Mircosoft excel formatting cells complicated
- Marksheet format in excel - Guide
- How to change date format in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to clear formatting in excel - Guide
- Number to words in excel - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 16, 2010 at 10:32 AM
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
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