View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Bill is offline
external usenet poster
 
Posts: 390
Default Filling a cell based on the content of another cell

I am trying to fill the column starting at R2 going down based on the data
contained in cell E2 going down. I want something like an If statement ot
fill the cells going down based the R column starting at R2. If the value in
E2 says infant then I would need R2 filled with Daycare otherwise the cell
would need to be filled with preschool.