Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting (Icon sets - 3 Arrows) | Excel Worksheet Functions | |||
Conditional Formatting with Icon sets | Excel Discussion (Misc queries) | |||
CF Icon Sets Traffic rimmed in excel2007 | Excel Worksheet Functions | |||
How do I apply icon sets to percentage values in Excel worksheet? | Excel Worksheet Functions | |||
Additional Icon Sets | Excel Discussion (Misc queries) |