Check if a cell has a formula.

  • Thread starter Thread starter diego.gomes
  • Start date Start date
D

diego.gomes

Hello,

I would like to know if there is a way to check if a cell has a valu
or a formula. I want to filter only the cells with no formulas.

Thankx
 
F5 > Special > Formulas > OK, will highlight all the cells with formulas.....

Vaya con Dios,
Chuck, CABGx3
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Excel VBA 1
Determine if time is within a windoww 2
Excel Need Countifs Formula Help 0
CountIf previous cell formula 0
Searching the formula (not the value) for a text string 1
Check for error.type in same cell 4
#DIV error 2

Back
Top