Testing a cell

N

Norma Vermilye

Does anybody know how to test a cell to determine if the
cell contains a formula? And then if the cell contains a
formula, change the cell font to a color (like blue)?
Thanks
 
K

Ken Wright

Select the whole sheet, do Edit / Go To / Special / select formulas, then just
hit the Blue font button
 

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

Copy addition formula of non-consecutive horizontal cells 2
Match table shading (color) to Visio color/Transparency 1
Excel does not accept text format! 0
Count Number of Unique Cells That Don't Have Certain Characters 0
Paste to excel from word - auto format problem 1
Need help modifying code 0
Excel help needed: Skipping cell without skipping cell reference 1
Testing a cell value for a specific weekday. 4

Top