I have a task sheet with a column for start date, end date and status. Is it possible to change the colour of the cell in the status column based on the date from the end date column? ie. when today's date matches the date in the end date column, the colour in the status column switches. any and all help is greatly appreciated.

Your looking for Conditional Formatting Start Date is in Cell A1 End Date is in Cell B1 Status is in Cell C1 1st – Select the cell C1 On the Menu Bar: 2nd - Format 3rd - Conditional Formatting 4th – Change “Cell Value is” to “Formula Is” 5th – Enter the formula: =IF($B$1=TODAY(),TRUE,FALSE) Sub Menu Format : 6th - Patterns 7th - Choose Green 8th - Press OK 9th - Press OK If you now enter Todays Date in cell B1 Cell C1 will change color to Green. Modify to suit your needs. MIKE http://www.skeptic.com/

Tks much for the answer Mike. I was working with conditional forumlas but messed up the IF statement string. Appreciate the help Cheers sean

Glad I could help. MIKE http://www.skeptic.com/

Tks much for the answer Mike. I was working with conditional forumlas but messed up the IF statement string. Appreciate the help Cheers sean