View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan Ryan is offline
external usenet poster
 
Posts: 124
Default Conditional formating

I would like to use a set of conditional formats to fill a cell with a
particular color based on that cell having a numeric value only in it. If the
cell is blank or contains text I want it to stay the original color so that
if the value "..1" is entered it remains the original color but if ".1" is
entered the cell will fill with 2nd color. Any suggestions?