Posted to microsoft.public.excel.programming

travis[_3_] travis[_3_] is offline

external usenet poster

Posts: 58

Highlighting rows in a range where ID code does not exist in s

On Oct 1, 9:23*pm, Barb Reinhardt
wrote:
=ISNA(vlookup({the address of the cell containing ID105},S:S,1,false)).

Let's say you select all of the cells you want to check. *For this example,
I'm going to say it's C1:C1000 and you start on cell C1

In the conditional format, put this

=ISNA(vlookup($C1,S:S,1,false)).

Does that work?

Actually, yes, it did. Thanks.

Travis

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
Code for Excel 2007 to hide rows based on sum of several rows not ina range	Joe Gardill	Excel Programming	2	August 29th 08 03:53 PM
Option Button Code (Highlighting Rows)	tvh	Excel Programming	5	August 8th 08 08:21 PM
range name does not exist	scory	Excel Discussion (Misc queries)	1	September 12th 06 01:17 PM
Compare a selected Range with a Named range and select cells that do not exist	PCLIVE	Excel Programming	1	October 18th 05 07:09 PM
does code for this exist? help please	short_n_curly[_6_]	Excel Programming	4	July 4th 05 01:39 AM

All times are GMT +1. The time now is 12:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us