Thread: if statement to shade cells (more than 3 conditions)
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mo2 Mo2 is offline
external usenet poster
  
Posts: 34
Default if statement to shade cells (more than 3 conditions)
If A4= 2, shade E4 blue
If A4= 3, shade E4 yellow
If A4=4, shade E4 brown
If A4=5, shade E4 orange
If A4=6, shade E4 purple

can't use conditional formatting (there is more than 3 conditions)

can anyone help?

P.S. i know nothing about visual basic
Reply With QuoteReply With Quote