need code to update cell when other cell changes

Hi There,

           I have this next code below which works but when cell color changes it dows not update automatically, just wondering how I can change it to make this happen.

Function CellColour(Irow As Integer, Icol As Integer) As Long
CellColour = Cells(Irow, Icol).Interior.ColorIndex
End Function

In the cell I have =IF(CellColour(1,3)=3,1,0)

Best regards


By: Pepe Agius

Leave a Reply

Your email address will not be published. Required fields are marked *