I'm trying to run a simple module that will assign a Boolean integer whether a cell is highlighted or not.

Here is my code in MVB

Function IsColor(x As Range) As Boolean
   If x.Interior.ColorIndex <> xlColorIndexNone Then
      IsColor = 0
   Else
      IsColor = 1
   End If
End Function

5/21/2015 11:24:02 PM

Can you set a boolean to 0 or 1 or should it be False and True?

5/22/2015 6:30:50 PM