View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JulieD JulieD is offline
external usenet poster
 
Posts: 618
Default lookup value and change background colour

Hi All

How do i (with code), lookup a cell - using the offset & match function -
and set the background colour to yellow..

the function i'm wanting to use is
=Offset(Product!$A$7,Match(B18,Categories,0),Match (C18,Months,0))

thanks
JulieD