Colors in an IF function w/ conditional formatting

[Enzo_Matrix]

I have multiple conditional formats and I want the cell to automatically change the text to 'High'/'Medium'/'Low' depending on the color generated by the formatting but can't seem to figure out how do it.

My conditional formatting is:
=AND($J17=5, $K17=5)
The formatting will change this cell to the color red or color index 3

This is currently what I have as the If function:

Function GetfillColor(Rng As range) As Long
GetfillColor = Rng.Interior.ColorIndex
End Function


Function CheckColor2(range)
If range.Interior.ColorIndex = 3 Then
CheckColor2 = "High"
ElseIf range.Interior.ColorIndex = 44 Then
CheckColor2 = "Medium"
ElseIf range.Interior.ColorIndex = 43 Then
CheckColor2 = "Low"
End If
End Function

I have multiple conditional formats and I want the cell to automatically change the text to 'High'/'Medium'/'Low' depending on the color generated by the formating but can't seem to figure out how do it.

 

[yky]

How do you get the other two colors, 44 and 43?

Instead of getting the color index, maybe you can use the rules that generate different colors in the IF formula, something like =IF(AND($J17=5, $K17=5), "HIGH", IF(....,...,)). If you want a VBA approach, then use "IF AND($J17=5, $K17=5) THEN ....".

 

[Enzo_Matrix]

How do you get the other two colors, 44 and 43?

Instead of getting the color index, maybe you can use the rules that generate different colors in the IF formula, something like =IF(AND($J17=5, $K17=5), "HIGH", IF(....,...,)). If you want a VBA approach, then use "IF AND($J17=5, $K17=5) THEN ....".

I get the other two colors by using the same functino 'Function GetfillColor(Rng As range) As Long' and apply it to 2 other cells with different colors in them.

I tried using the =IF(AND in the conditional formatting formula but it will not apply properly. =IF, =AND both work indignantly though which is odd. Is there something in my workbook or settings that would limit the types of formula you can use in 'Conditional Formatting'?

 

[yky]

I don't know any settings that would do that.

What odd results did you get?

 

[Enzo_Matrix]

Thanks for your assistance in this, I have however decided to take an alternate route to the same result.

This https://www.mrexcel.com/forum/excel...simplify-consolidate-if-code.html#post4984418 is the new thread for my new approach.