Conditional formatting - Percentage

karthickerfolg

New Member
Joined
Apr 18, 2021
Messages
1
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

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
5,226
Office Version
  1. 2013
Platform
  1. Windows
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,976
Messages
5,656,184
Members
418,288
Latest member
reba557

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
Top