I would like a simple way to identify hard coded numbers versus formulas in spreadsheets. I suspect what I want has to do with conditional formatting. I would like to easily see which of hundreds of cells are hard coded. If they could display in a different color or font, that would be great. I am trying to avoid doing a search for the = sign. Some of the cells should be hard coded and some should be formulas. I'm looking for ones that are out of place, like on number in a column of formulas which has been overwritten.
thanks
thanks