Hi

I am trying to put together a worksheet where the user would enter the date
in Cell A1 - format of 01/01/07 and cell A2 returns the day of the week
"MON".

This is fine - what I need to do now is check that A2 = "Mon" and A3 = "Demo"
then change the font colour. I can do the if statement, however am unable
to workout how I can detect when cell A2 is updated.

Thanks in advance for any help.