Conditional Formatting for %

O

Oaksy88

New Member
Joined
Oct 11, 2023
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
Hello community. First time posting one of these so I hope it makes sense.

I am trying to use conditional monitoring to highlight a percentage loss from the Minimum recorded thickness (shown in V5-V29) from the original thickness (shown in D5-D29. I want to highlight the following:
  • Any numbers that are below a certain percentage (-12.6% mill tolerance) colored in red.
  • Any numbers that are above a certain percentage (-12.5% mill tolerance) colored in green.
The original thickness changes constantly so I think i need a formula chich can be inputted into each spreadsheet.

ISOs.xlsx
ABCDEFGHIJKLMNOPQRSTUVW
3CML No:CML FeatNPSOrig ThickDist FromTop Bottom North EastSouthWest IntExMin
4 ("/SCH)(mm)Start (mm)MaxMinMaxMinMaxMinMaxMinMaxMinMaxMinMaxMinMaxMinComments
51Straight (AW)30"/ Unk26.975027.927.927.927.927.9
62Straight30"/ Unk26.97275028.028.128.028.028.0
73Straight30"/ Unk26.97600028.128.328.228.228.1
84Pipe Support30"/ Unk26.97940028.028.128.328.228.0
95Straight (BW)30"/ Unk26.971203028.128.028.228.128.0
106Straight (AW)30"/ Unk26.971208027.627.927.827.927.6
117Straight30"/ Unk26.971554027.827.927.928.027.8
128Straight30"/ Unk26.971929027.927.928.027.927.9
139Pipe Support30"/ Unk26.972149027.927.927.927.927.9
1410Straight (BW)30"/ Unk26.972422027.827.828.227.927.8
1511Straight (AW)30"/ Unk26.972427027.627.727.727.727.6
1612Straight30"/ Unk26.972717027.728.227.827.927.7
1713Straight30"/ Unk26.973077027.728.128.027.727.7
1814Pipe Support30"/ Unk26.973363027.627.827.727.827.6
1915Straight (BW)30"/ Unk26.973636027.727.527.727.527.5
2016Straight (AW)30"/ Unk26.973641027.627.927.827.727.6
2117Straight30"/ Unk26.973961027.727.627.827.727.6
2218Straight30"/ Unk26.974291028.128.127.827.827.8
2319Pipe Support30"/ Unk26.974571027.628.128.228.027.6
2420Straight (BW)30"/ Unk26.974851028.428.028.027.627.6
2521Straight (AW)30"/ Unk26.974856028.027.927.827.727.7
2622Straight (BW)30"/ Unk26.975086028.227.927.827.927.8
2723AElbow (AW)30"/ Unk26.975091029.730.030.030.029.7
2823BElbow (Centre)30"/ Unk26.9752110No Access
2923CElbow (BW)30"/ Unk26.9753310No Access
2277-050-020-ISO-058
Cell Formulas
RangeFormula
V5:V27V5=MIN(F5:U5)
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
How are you calculating the percentages? That is not shown in your sheet. When I run that on your numbers they are all in the +1-4% range. No negative percentages, so I must not understand what you are trying to calculate. I am calculating

(Min-Orig Thick)/Orig Thick
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,880
Messages
6,175,157
Members
452,615
Latest member
bogeys2birdies

Share this page

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