Forum Discussion
Ravindu94
Jun 24, 2020Brass Contributor
conditional formatting to highlight number of cells based on count
hi, I've attached my production plan file. i need to highlight cells based on shifts taking for the production. as a example if i have 100,000 pcs to produce and my capacity is 250,000 per shift. it...
- Jun 24, 2020
Ravindu94 Changed the formula a little bit. Forgot to add "+12/24" to the first part of teh Night-shift formulae. See attached
Ravindu94
Jun 24, 2020Brass Contributor
Riny_van_Eekelen thank you very much for your respond . its really good. i have small trouble. if 1st production end at day shift how can i start same day night shift production
Riny_van_Eekelen
Jun 24, 2020Platinum Contributor
Ravindu94 Changed the formula a little bit. Forgot to add "+12/24" to the first part of teh Night-shift formulae. See attached
- Ravindu94Jun 24, 2020Brass Contributor
Riny_van_Eekelen many thanx you're great