Excel VBA if cell color is enter manually, then make next cell true

Question

I need help with a VBA code based on a cell that's colored manually. Basically, if the cell is green, then make another cell to say "True", if it's not colored, then "False" Example

Thank you !

Answer 1

If ActiveCell.Interior.Color = RGB(X,X,X) Then
   ActiveCell.Offset(0,1).Value = "True"
Else
   ActiveCell.Offset(0,1).Value = "False"
End If

Set the RGB value to be whatever 'green' color you're currently using. You can loop through a range to set the values.