Referencing Icon Sets

[BLR]

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?

 

[T. Valko]

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","")

 

[Shane Devenshire]

Hi,

Since you may not know the exact condition that is triggering the icon -
select the range with the conditional formatting and choose Home, Conditional
Formatting, Manage Rules, select your rule and click Edit Rule. Note the
conditions, then write formulas in column B which take the values into
account as Biff suggested.

 

[BLR]

The icon set is based on percentiles....not a specific number. How do I write
the =IF(A1<0,"Warning","") using percentitiles not specific numbers?

Thanks,
Brent