How can I change cell color using conditional formatting

[Guest]

I'm sure the answer to this is "conditional formatting", but I don't know how
to get it to work...

I have a spreadsheet I use to track employee training on procedures. One
column lists the date the procedure is active and another column lists the
date an employees training on it. When the procedure changes I update the
appropriate cell in the first column to show the new date. I want the cell
containing the employee training date to change color if the dates don't
match. How would I do that?

 

[Paul B]

Brian, with date the procedure is active in column A and employee training
date in column B, select your dates in column B and put in conditional
formatting cell valve is, not equal to =A1

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003