conditional format with formula

S

snax500

In Excel 2007, is there a way to use conditional formating to
highlight cells that have a formula. I want to highlight only cells
with any type of formula. If it is a value I do not want any
highlight. I want to do this only thru conditional formatting not with
a macro.

Thanks
 

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

Conditional Formatting question.... 1
Conditional Formatting 2
can conditional formatting varry the area it highlights based on c 3
Changing row background from external program 0
Automatically Scheduled Task with Start on Constraint and Neg Slack 0
error in highlighting duplicate values in excel 1
Conditional formatting disappears when cell contents deleted 2
conditional formatting 1

Top