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
rizvisa1 Posts 4479 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
- Excel date format dd.mm.yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains any text ✓ - Excel Forum
- Transfer data from one excel worksheet to another automatically - Guide
- Conditional format based on another cell containing text - Excel Forum
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
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
