[lacticacid]

I have this spreadsheet and in it it automatically sets up time-lines for a project. However sometimes these automatically set timelines have to be changed so a date is hardcoded in. Is there a way to have excel conditionally format say formula driven fields say light blue and hand entered ones white. So the cell would change from lightblue to white when someone hand types in the info. I looked at conditional formatting and it doesn't seam to work for this.

Thanks.