Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BLR BLR is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15,768
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,346
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BLR BLR is offline
external usenet poster
 
Posts: 5
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting (Icon sets - 3 Arrows) Jackie Excel Worksheet Functions 3 April 3rd 23 02:37 PM
Conditional Formatting with Icon sets CC Excel Discussion (Misc queries) 4 April 21st 10 03:34 PM
CF Icon Sets Traffic rimmed in excel2007 Sandeep Excel Worksheet Functions 0 October 23rd 08 03:53 AM
How do I apply icon sets to percentage values in Excel worksheet? Still Learning? Excel Worksheet Functions 1 April 24th 08 12:14 AM
Additional Icon Sets Kevin S Excel Discussion (Misc queries) 0 July 3rd 07 03:18 PM


All times are GMT +1. The time now is 08:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"