View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BLR BLR is offline
external usenet poster
 
Posts: 5
Default Referencing Icon Sets

Cells A1:A1000 contains a conditional formating Icon Set (red x, !, and check
mark)
I want Cells B1:B1000 to enter automatically insert text based on the Icon
in the A column.
Examples:
A1 contains a red x icon....i want B1 to put automatically put the text
warning.

Any suggestions?