Posted to microsoft.public.excel.misc

snax500

external usenet poster

Posts: 49

conditional format with formula

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Format Formula	Mike	Excel Discussion (Misc queries)	5	April 14th 08 09:09 PM
conditional format formula	dzelnio	Excel Discussion (Misc queries)	3	August 22nd 07 05:52 PM
Conditional format formula	Shu of AZ	Excel Discussion (Misc queries)	1	November 26th 06 07:27 PM
Conditional Format & Formula	Bob	Excel Worksheet Functions	2	November 3rd 06 09:27 PM
Conditional format with a formula	Mike Echo	Excel Worksheet Functions	6	July 19th 05 11:05 AM

All times are GMT +1. The time now is 06:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us