Conditional formatting - Percentage

karthickerfolg

New Member
Joined
Apr 18, 2021
Messages
3
Office Version
  1. 2019
Platform
  1. Windows
Dear Team,

I want to do conditional formatting on the basis of percentage available. I have stocks available at the beginning of a month listed in a column and the stock available as on date in the second column. If the stock available level is 67% or more of the original quantity, the cell of quantity available today should be green. Between 34 and 66% it should be yellow and below 33% it should be red. I am unable to do this. Kindly help.

TypeQuantity as on April 1st Quantity available today
Screws540540
Plates - A360330
Plates - B450351
Plates - C331300
Plates - D4540
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
Maybe try like....
Book1-April.xlsm
ABC
1TypeQuantity as on April 1st Quantity available today
2Screws360242
3Plates - A360241
4Plates - B45037
5Plates - C331250
6Plates - D4530
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
C2:C8Expression=C2/B2>=0.67textYES
C2:C8Expression=C2/B2>0.34textYES
C2:C8Expression=C2/B2>0textYES
C3:C6Other TypeColor scaleNO


Hope that helps.
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

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