HELP:Color code values with function in excell

[tns5852]

Hi,

I have values that I want to color code in my table. Originally I was tagging them as numbers, but instead I need them as colors.


Function conversion(pVal As Double)

If pVal > 0.05 Then
conversion = "1"
ElseIf pVal > 0.001 Then
conversion = "2"
ElseIf pVal > 0.0001 Then
conversion = "3"
ElseIf pVal > 0.00001 Then
conversion = "4"

End If

End Function



Now I want instead of conversion = "1" etc to be

Function conversion(pVal As Double)

If pVal > 0.05 Then
(make white)
ElseIf pVal > 0.001 Then
(make brighter blue)
ElseIf pVal > 0.0001 Then
(make green)
ElseIf pVal > 0.00001 Then
(make navy blue)

End If

End Function

I want the text and cell the same color (number and cell so the number disappears so that I just have a colored cell but the value is still there if I want to look at it).


Please help me! I am confused as to how to do this

<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[wigi]

when I tried running it, however, nothing happened

Could be. The cells might not be numbers, to name but 1 reason.

 

[tns5852]

The cells are long decimals, but they are numbers. My function for tagging the values as 1 2 3 4 (original one) worked. (It could read the number and return the respective integer). Reading the values and returning colors is not.
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

 

[wigi]

I did not change your conditions, hence I would not directly see the problem.

 

[tns5852]

I did conditional formatting. Only downside is there are few options with conditional formatting, but this was a good compromise. Thanks everyone!
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">