Remember Me?

#1
January 4th 17, 05:51 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 177
conditional formatting, bleh

trying to use this formula for conditional formatting in column D:
=NOT(ISNA(VLOOKUP(D1, SLS_Holidays, 1, FALSE)))

where any value in D that is found in SLS_Holidays will be highlighted. It wont accept copy/paste, and attempts at modifying it are not getting me anywhere. please help.

#2
January 4th 17, 06:04 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,555
conditional formatting, bleh

Hi Matthew,

Am Wed, 4 Jan 2017 08:51:23 -0800 (PST) schrieb Matthew Dyer:

trying to use this formula for conditional formatting in column D:
=NOT(ISNA(VLOOKUP(D1, SLS_Holidays, 1, FALSE)))

try in CF:
=COUNTIF(SLS_Holidays,D1)0

Regards
Claus B.
--
Windows10
Office 2016
#3
January 4th 17, 06:11 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 177
conditional formatting, bleh

On Wednesday, January 4, 2017 at 10:04:22 AM UTC-7, Claus Busch wrote:
Hi Matthew,

Am Wed, 4 Jan 2017 08:51:23 -0800 (PST) schrieb Matthew Dyer:

trying to use this formula for conditional formatting in column D:
=NOT(ISNA(VLOOKUP(D1, SLS_Holidays, 1, FALSE)))

try in CF:
=COUNTIF(SLS_Holidays,D1)0

Regards
Claus B.
--
Windows10
Office 2016

so I must be doing something wrong - when I copy/paste your formula directly into CF I get an broken formula error. I take out the = and hit OK, it puts it back in, and surrounds the formula with "s
#4
January 4th 17, 06:28 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,555
conditional formatting, bleh

Hi Matthew,

Am Wed, 4 Jan 2017 09:11:47 -0800 (PST) schrieb Matthew Dyer:

so I must be doing something wrong - when I copy/paste your formula directly into CF I get an broken formula error. I take out the = and hit OK, it puts it back in, and surrounds the formula with "s

in CF you cannot use sheet scope names. Is you name a global name, a
workbook scope name?

Regards
Claus B.
--
Windows10
Office 2016
#5
January 4th 17, 06:59 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 177
conditional formatting, bleh

On Wednesday, January 4, 2017 at 10:28:30 AM UTC-7, Claus Busch wrote:
Hi Matthew,

Am Wed, 4 Jan 2017 09:11:47 -0800 (PST) schrieb Matthew Dyer:

so I must be doing something wrong - when I copy/paste your formula directly into CF I get an broken formula error. I take out the = and hit OK, it puts it back in, and surrounds the formula with "s

in CF you cannot use sheet scope names. Is you name a global name, a
workbook scope name?

Regards
Claus B.
--
Windows10
Office 2016

workbook scope - it's a table name

#6
January 4th 17, 07:18 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 177
conditional formatting, bleh

On Wednesday, January 4, 2017 at 10:59:28 AM UTC-7, Matthew Dyer wrote:
On Wednesday, January 4, 2017 at 10:28:30 AM UTC-7, Claus Busch wrote:
Hi Matthew,

Am Wed, 4 Jan 2017 09:11:47 -0800 (PST) schrieb Matthew Dyer:

so I must be doing something wrong - when I copy/paste your formula directly into CF I get an broken formula error. I take out the = and hit OK, it puts it back in, and surrounds the formula with "s

in CF you cannot use sheet scope names. Is you name a global name, a
workbook scope name?

Regards
Claus B.
--
Windows10
Office 2016

workbook scope - it's a table name

for the immediate I just hard-coded my range (H2:H20), but I would appreciate if someone could tell me how I could use my named range instead.
#7
January 4th 17, 07:24 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Apr 2011 Posts: 3,555
conditional formatting, bleh

Hi Matthew,

Am Wed, 4 Jan 2017 10:18:15 -0800 (PST) schrieb Matthew Dyer:

for the immediate I just hard-coded my range (H2:H20), but I would appreciate if someone could tell me how I could use my named range instead.

have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYVbEmzNp--N_HbuEw

Regards
Claus B.
--
Windows10
Office 2016
#8
January 6th 17, 02:52 PM posted to microsoft.public.excel.programming
 external usenet poster First recorded activity by ExcelBanter: Aug 2009 Posts: 177
conditional formatting, bleh

On Wednesday, January 4, 2017 at 11:24:35 AM UTC-7, Claus Busch wrote:
Hi Matthew,

Am Wed, 4 Jan 2017 10:18:15 -0800 (PST) schrieb Matthew Dyer:

for the immediate I just hard-coded my range (H2:H20), but I would appreciate if someone could tell me how I could use my named range instead.

have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgYVbEmzNp--N_HbuEw

Regards
Claus B.
--
Windows10
Office 2016

Sorry Claus, but it appears to be a broken link

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

 Similar Threads Thread Thread Starter Forum Replies Last Post Patrick Harris Excel Discussion (Misc queries) 0 April 9th 09 12:00 AM Tammy S. Excel Discussion (Misc queries) 3 March 30th 09 08:11 PM The Rook[_2_] Excel Discussion (Misc queries) 3 March 7th 09 09:48 PM Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 06:32 PM BrainFart Excel Worksheet Functions 1 September 13th 05 05:45 PM

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