View Single Post
  #8   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

Hi Bob, more specifically, if the cell is <=59 the cell itself 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.