Thread: Insert text based on another cell's colour or font in Excel 2003
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
Philip Hinton Philip Hinton is offline
external usenet poster
  
Posts: 4
Default Insert text based on another cell's colour or font in Excel 2003
eI have a table of data (b2:f600). Some of the rows are green, some yellow,
etc. I need a formula/macro that will put a number or text in column A based
on the row's colour (eg if b2 is green then put "1" or "green" in a2). The
coloured rows are not in consecutive order. I use Excel 2003. Anyone?
Reply With QuoteReply With Quote