calculating percentage based on cell values

[DB73]

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)

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

 

[kvsrinivasamurthy]

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%

 

[DB73]

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