You want to base the text entered in column B on the value of the cell in
column A that causes the particular icon.

You say you want the text "Warning" when the "red x" icon is present. So,
what is the conditon that causes the "red x" icon? For example, A1 = -10,
the "red x" icon displays for values <0.

=IF(A1<0,"Warning","")

--
Biff
Microsoft Excel MVP


"BLR" wrote in message
...
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?