karthickerfolg
New Member
- Joined
- Apr 18, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- 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.
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.
Type | Quantity as on April 1st | Quantity available today |
Screws | 540 | 540 |
Plates - A | 360 | 330 |
Plates - B | 450 | 351 |
Plates - C | 331 | 300 |
Plates - D | 45 | 40 |