Formula Identifier

N

Nicole Mantie

Has anyone had any luck trying to identify a formula in a
cell from a value in a cell?

I need to use seom logic in a cell to tell me if another
cell is a formula or a value.

HELP!
 
P

Peo Sjoblom

Press F5, select special, select formulas, click OK
Then you can select a fill colour. Else you have to use
VBA..

Regards,

Peo Sjoblom
 

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

Newbie Help - IF Yes No Function 0
Copy addition formula of non-consecutive horizontal cells 2
Macro to select and delete levels of a document 2
Autonumber field in Excel that behaves the same as Access 0
Excel - Wich Function should I use? 1
Drop down list control value in vba 2
Tagging Misspell Words with "##" 0
Office JS api to handle redo/undo , delete event for content control class 0

Top