formula in a cell or not?

M

michel beuseling

Excelfanatics

I'm trying to make interactive exercises for my students.
How can I detect if a value in a cell is the result of a formula in the cell
or not?

Thanks
 
M

Max

If you press F5 > Special > Check "Formulas" > OK
it'll select the cells with formulas in the sheet
 
Top