Solved: Allow user to set Percentage

[Djblois]

I want to allow my users to set the percentage they want to highlight if less then. I know how to save a number setting but I can't seem to get a percentage to work. This is the code that I am trying:


HighlightPercentage = GetSetting("Business Reporting Today", "InvoiceReportOptions", "Profit Percentage", 10) * 0.01
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlLess, Formula1:=HighlightPercentage

[Bob Phillips]

A percentage is just a number, between 0 and 1.