Cell back color

[amir0914]

Hi all, I wrote a small function to use in excel range, but it gives error to cell back color, Does someone know why actually it gives error in cell ??



Function pp(tx As Range)
If tx > 1 Then
pp = 103
tx.Interior.Color = vbRed
End If
End Function

26314

[YasserKhalil]

You can't change the interior color through using UDF. Try using normal sub instead.

[Paul_Hossler]

Or Conditional Formatting

[amir0914]

Thank you, I did it so easily with Conditional formatting.