Say your master cell is B1 =today()
Select (example) range A2:D20,
Go to Format, Conditional Formatting
From Dropdown, FormulaIs
In box enter =A2=$B$1
then clicl Format... button
select pattern (color)
OK out..

"JohnHaslam" wrote in
message ...

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