Formula which changes value of the cell based on the color of other cell in Excel
Function stuff(a As Range, b)
If a.Cells().Interior.ColorIndex = 4 Then
stuff = b
End If
End Function
If a.Cells().Interior.ColorIndex = 4 Then
stuff = b
End If
End Function
Komentarai