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 Format

Would anyone have a VBA code for a macro that changes the color of a cell
according to 5 different rules? If the cell is <=59 the cell becomes blue,
if its <=69 it becomes green, if its <=79 it becomes yellow, if its <=89
it becomes orange and if its <=100 it becomes black.
Thanks