Thread: conditional formatting, bleh
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 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
Reply With QuoteReply With Quote