Posts: n/a

How do I highlight all lookup formulas in a worksheet in one shot.

I need to implement cell protection to all cells with lookup formula in a
worksheet. I know GOTO-Special can highlight all the formula cells, but I
need some way more specific to pick and highlight only the lookup formula.

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
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM
Lookup last in column formulas	L. Howard Kittle	Excel Discussion (Misc queries)	6	January 15th 05 05:38 AM
How to make Excel run limited number of formulas on a given worksh	John	Excel Discussion (Misc queries)	0	January 12th 05 04:29 PM
Highlight formulas	Philip Reece-Heal	Excel Worksheet Functions	1	November 10th 04 06:54 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 04:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us