View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Matthew Dyer Matthew Dyer is offline
external usenet poster
 
Posts: 178
Default 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