Hi all,

I'm still getting to grips with the finer points of Excel, and can't
work out whether the following is possible:

On my worksheet I have a "master" date, which is always today's date.
In other cells, other dates will appear. What I'm after is to put a
formula in these cells, so when a cell's date matches the "master" date
the colour fill of that cell changes to whatever I like. In effect, that
days' work would be flagged up at a glance.

As I say, I'm new to the formula / programming side of Excel so don't
even kow if this is possible - but can someone help me if it is?

Thanks,

John


--
JohnHaslam
------------------------------------------------------------------------
JohnHaslam's Profile: http://www.excelforum.com/member.php...o&userid=29742
View this thread: http://www.excelforum.com/showthread...hreadid=494562