View Full Version : Excel Help

10-06-2005, 11:24 AM
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.


10-06-2005, 11:49 AM
I think the only way to do this is to program it in VBA for Excel.

I don't think you can do it using the formulas.

10-06-2005, 02:47 PM
1) Go to Insert->Name->Define.
2) Type 'HasFormula' in the box at the top
3) In the 'Refers to:' box at the bottom type this exactly: =GET.CELL(48,INDIRECT("rc",FALSE))
4) Click OK
5) Highlight the area you'd like to conditionally format
6) Go to Format->Conditional Formatting
7) Select Formula Is from the dropdown
8) Type =HasFormula in the box to the right
9) Click the Format button and select your formatting

Voila! Pretty neat eh? Got that from mrexcel.com's message boards via google. Credit to Ian who posted it.