Thread: Conditional Formatting - 2 Worksheets one Named Range
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
  
Posts: 247
Default Conditional Formatting - 2 Worksheets one Named Range
Hi Max,

Thank you very much for your time and assistance. The Formula works Great!

Cheers,
Sam

Max wrote:
Another play, using your named range YR2006

Select K17:K100 in Sheet1,
then apply the CF using the formula:
=AND(N170,N17=INDEX(YR2006,ROW(A1)))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1

Reply With QuoteReply With Quote