I have a column of numbers (in percentages) which is a part of a pivot table. I need to color code this column as follows:
- Percentages above 95% "Good"
- Percentages >= 90% and lower than 95% "Neutral"
- Percentages < 90% "Bad"
I would like to use Excel Styles for colors.
I have written...
Public Function ColorSum(ByVal target As Range, ByVal MyColor As String)
Dim Blacksum As Long, Othersum As Long, cel As Range
Blacksum = 0
Othersum = 0
For Each cel In target
If IsNumeric(cel.Value) Then
If cel.Font.ColorIndex = 1 Then
Blacksum = Blacksum +...
I have a spreadsheet wherein I need to extract the minimum value from 4 Suppliers. The suppliers are colour coded, and i would like the extracted amount to show the suppliers colour code as well as the value.
I am merely using currently the Min function. Can anyone assist me...