Adding If/Then to format cells based on date

Hello,

I'm working on an interactive calendar and I would like to add two functions to an active X button. This is my code at the moment:

Please Login or Register  to view this content.

Both functions would do something like "If value in A1 is less than 25" then format cell "A2" color and text as in my previous code, just either in a different column.

Thanks for any help,

Cheers,

It's not clear (to me at least) what you're trying to achieve. So if A1 is <25 then change the colour of A2, and then what??

BSB

Originally Posted by BadlySpelledBuoy

It's not clear (to me at least) what you're trying to achieve. So if A1 is <25 then change the colour of A2, and then what??

BSB

That's it. Change the color of A2 and put a small text in the cell.