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