Using logic to change the fill in a cell
 

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

Using logic to change the fill in a cell
 

John, you can use conditional formatting to change the colour of a cell
when the cell matches the master date. See he
http://www.scottmanning.com/archives/000351.php for instructions, or
search using the keywords: conditional formatting excel


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

Using logic to change the fill in a cell
 

Hi

You need Conditional Formatting. Select one of the 'other' cells and go to
Format / Conditional Formatting. Set the first option to 'Formula is' and in
the next box enter:
=$A$1=B1
where your master date is in A1 and the 'other' cell you are in is B1. Then
you can set your format.
You can find some more info he
http://www.cpearson.com/excel/cformatting.htm

Hope this helps.
Andy.

"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

Using logic to change the fill in a cell
 

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