Using logic to change the fill in a cell

J

JohnHaslam

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
 
G

Guest

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 here:
http://www.cpearson.com/excel/cformatting.htm

Hope this helps.
Andy.
 
J

JMay

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..
 
Top