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
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