View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kb489 kb489 is offline
external usenet poster
 
Posts: 1
Default Assigning Color to a number

I am trying to assign a color to a row depending on the number placed in the
first columb. For example when cell A1 = 4, I want the computer to make
cells A1-D1 to be light blue in color. When the "4" changes to "5" the color
needs to change to green. Is this possible and how.
--
Thank you for your help. KB489