Identify Formula vs Number

[DCSwearingen]

Is there a function that will allow determinng if a cell contains a formula or an actual number?

[NBVC]

Yes you can...

see this link....

http://www.sulprobil.com/html/get_cell.html

and this link will show how to highlight cells with formulas: http://www.j-walk.com/ss/excel/usertips/tip045.htm

[DCSwearingen]

Thank you for pointing me in the right direction.

After reading the two links, I looked for a VBA property and found I could use

Please Login or Register  to view this content.

Now we can use the function directly in the worksheet formulas.

Occassionally a Month-to-Date or YTD adjustment is entered over the running weighted averages for out percent solids (or whatever) and if this happens to be the case our next calculation will "know" this by referenceing through the above UDF and will calculate based on the adjusted MTD or YTD number rather than on the original daily units.

I have also set up a conditional format using this function to flag when one of the adjustments is made to the spreadsheet by manually entering a value.

Conditional Formatting formula is

Please Login or Register  to view this content.

where A2 happens to be the cell to highlight in this case. By selecting that cell and then highlighting the remaining spreadsheet, going through the Conditional formatting process again all cells are now set as long as the relative cell address is used and not the absolute...