Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Brian" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change color of text in cell without conditional formatting | Excel Discussion (Misc queries) | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) |