Cell interior color changer function

**randomdude** · 01-20-2015, 04:54 AM

Hi again, this little function's goal would be to check the cells in the selected range, and if there's a 0 there, change the color of the cell's - where the user wrote the function - color to green. I get #VALUE! when I run it, but if I comment out the actual "Cells(row, column).Interior.Color = vbGreen" line, it works fine, but obviously not changing the cell's color. Here's the code:

Please Login or Register  to view this content.

Thanks for your help.

**watersev** · 01-20-2015, 06:42 AM

hi randomdude, function is supposed to return value or array of values, it can not change color

**TMS** · 01-20-2015, 06:48 AM

Why don't you just use Conditional Formatting?

Or, you could use a Custom Format to hide zeroes.

Or, you could use a worksheet change event handler to monitor the cells and change the colour.

Just not a User Defined Function used as a worksheet function.

Regards, TMS