Thread: VBA code for 5-rule Conditional Formating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Antonio Antonio is offline
external usenet poster
  
Posts: 134
Default VBA code for 5-rule Conditional Formating
Would anyone have a VAb code for a macro that changes the color of a cell
according to 5 different rules? A2 would be black if A1=1, green if A1=2,
gray if A1=3, blue if A1=4 or gold if A1=5.
Thanks
Reply With QuoteReply With Quote