View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bliten_bsas bliten_bsas is offline
external usenet poster
 
Posts: 7
Default Column shading color based on specific cell content

Hi all, I'm trying to write a macro that shades a specific range of
columns depending on the contents of another cell. For example, I want
to shade in green all columns whose date (that's the column heading) is
less or equal to a specific date to be inputed in another cell. How can
I do that??