calculating percentage based on cell values

DB73

Board Regular
Joined
Jun 7, 2022
Messages
107
Office Version
  1. 365
  2. 2021
  3. 2019
  4. 2016
  5. 2010
  6. 2007
Platform
  1. Windows
  2. Mobile
  3. Web
Hey guys,

its been a while but now i have a new question

with what formula can i calculate how much percentage is left (J10)
1728900433300.png



i want to have a conditional formating in J10 based on J9 and also the percentage in cell J10
between 5% and lower - red color
between 8% and 5% - orange color
between from 8% and higher - green color

Tnom. is given (changes from a table when is choose)
measured WT is a given value with max as Tnom.
So , the 0.28 in J9 is a certain percentage from the difference between J5 and J7 that i want in J10.
When E5 and J7 are the same its 0%
When measured WT in J7 is the same as in J5 it should be 100%
Retire is J7

I cant upload the file and also the MrExcel addon doest work due restrictions here on my work device

Do i need a formula and / or needed in conditional formating ?

thank in advance
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
May be this. In J10

=(J7-J5)/J5

Format the cell for percentage.
For CF
For Red.
Formula is
=J10<=5%
Select J10
Home-->Conditional formatting-->New rule
Select --> use a formula .......
Enter the the formula
Select --> format --> select red color-->OK

For orange
=AND(J10>5%,J10<=8%)

For Green
=J10>8%
 
Upvote 0
May be this. In J10

=(J7-J5)/J5

Format the cell for percentage.
For CF
For Red.
Formula is
=J10<=5%
Select J10
Home-->Conditional formatting-->New rule
Select --> use a formula .......
Enter the the formula
Select --> format --> select red color-->OK

For orange
=AND(J10>5%,J10<=8%)

For Green
=J10>8%
This was the solution for me...many thanks (y):giggle:
 
Upvote 0

Forum statistics

Threads
1,224,465
Messages
6,178,821
Members
452,881
Latest member
motivationgyan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top