RSummersJr@gmail.com wrote:
> Hello,
>
> I'm trying to setup a macro that will automatically change the color of
> a cell's background when the cell's date data equals TODAY(). I know I
> can do this with conditional formatting, but I also need it to change
> to another color once a checkbox has been checked, and this will not
> work with conditional formatting (any changes to the background color
> will be overridden by the conditional formatting). Is there anyway to
> do this in VBcode? Any help would be fantastic. Thanks!
>
> Rick
>
Hi Rick,
this command colors define the color of cell a1

If DateDiff("d", Range("a1").Value, Now()) = 0 Then
Range("a1").Interior.Color = RGB(0, 255, 0)
End If

Mike from Luxembourg