View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brian brian is offline
external usenet poster
 
Posts: 22
Default Colour formatting with VBA

Excel menu allows me to conditionally colour formate a selected range, based
on cell values, up to 3 conditions - i.e. a choice of only 3 colours. Can I
colour formate cells that have value in steps of ten (1-10, 11-20,
.......81-90 and 91-100) using VBA? This is my preferred choice. If not can
it be done using coloured fonts? Thanks for any help.

TIA
Brian