Thread: How do I change the color of cells with a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike DFR Mike DFR is offline
external usenet poster
  
Posts: 5
Default How do I change the color of cells with a macro
I was using conditional formatting, but this only gives three options, I need 5
I am looking for a simple piece of code which says

If cell A1 is not zero color the row green, for example.

I have tried With range, If Else and Case

I get the first color, then it will not change
Reply With QuoteReply With Quote