View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DanL DanL is offline
external usenet poster
 
Posts: 9
Default change background color based on range value

I would like to search a spread sheet for a specific range value Ie

c1 c2 c3 c4 c5 c6
20 30 40
20 30 40

When 20 30 and 40 are found in neighboring columns I would like to turn the
background of these 3 cells blue. How would I code this?

Thanks in advance - Dan