View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ukemann
 
Posts: n/a
Default color coordinate web query data based on the number being + or -

I am trying to color coordinate data which is being imported into excel
though a web query based on the number being either positive or negative.
Does anyone know if it is possible to write a macro which would do this.
Sometimes the numbers will be positive and therefore I want them to show up
in green and other times the numbers will be negative and I would want them
to show up in red.