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?