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
In the cell I have =IF(CellColour(1,3)=3,1,0)
By: Pepe Agius