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?

Referencing Icon Sets
 

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?

Referencing Icon Sets
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"BLR" wrote:

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?

Referencing Icon Sets
 

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

"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"BLR" wrote:

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?