Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 25th 10, 09:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 18
Default Icon Sets - Display icon in one cell depending upon value in anoth

I would like to display in cell A2 a red diamond if the value in
U2="Storage"; a Green Circle if the value in U2="Central Files" "Office" or
Floor"; and a yellow triangle if the value in U2="Missing".

I saw the response to "ICON Arrows UP or DOWN", but I couldn't understand
where the different parts were supposed to go.

  #2   Report Post  
Old February 25th 10, 10:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2007
Posts: 11
Default Icon Sets - Display icon in one cell depending upon value in anoth

Nolene, you can put an IF statement in column A that reflects the information
in column U:

=IF(U2="Storage", 1,IF(or(U2="Central
File",U2="Office",U2="Floor"),2,IF(U2="Missing"),1 ,""))))

I think I have enough closing parenthesis there . .

Then, use conditional formatting to define if the result in column A is 1
then . . . if the result in column A is 2 then etc

I didn't however double check to make sure than conditional formatting has a
set of icons that included a red diamond, a green circle and a yellow
triangle --

"Nolene" wrote:

I would like to display in cell A2 a red diamond if the value in
U2="Storage"; a Green Circle if the value in U2="Central Files" "Office" or
Floor"; and a yellow triangle if the value in U2="Missing".

I saw the response to "ICON Arrows UP or DOWN", but I couldn't understand
where the different parts were supposed to go.

  #3   Report Post  
Old February 26th 10, 05:43 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 18
Default Icon Sets - Display icon in one cell depending upon value in a

That worked. I guess I should have said that this was for using Conditional
Formatting Icon Sets in Excel 2007.

I didn't quite understand how to enter the data for the icons, but I figured
it out. For others wondering, I gave the entire column A Conditional
Formatting with the Icon Sets with the 3 signs style and Show Icon Only. Then
I made the green value = 3 and chose number for the Type; and yellow =2
(number). Then I had to fix the formula so that Central Files/Office/Floor
was 3 (instead of 2) and Missing was 2 (instead of 1). Then I just copied it
down the column.

"nita" wrote:

Nolene, you can put an IF statement in column A that reflects the information
in column U:

=IF(U2="Storage", 1,IF(or(U2="Central File",U2="Office",U2="Floor"),2,IF(U2="Missing"),1 ,""))))

I think I have enough closing parenthesis there . .

Then, use conditional formatting to define if the result in column A is 1
then . . . if the result in column A is 2 then etc

I didn't however double check to make sure than conditional formatting has a
set of icons that included a red diamond, a green circle and a yellow
triangle --

"Nolene" wrote:

I would like to display in cell A2 a red diamond if the value in
U2="Storage"; a Green Circle if the value in U2="Central Files" "Office" or
Floor"; and a yellow triangle if the value in U2="Missing".

I saw the response to "ICON Arrows UP or DOWN", but I couldn't understand
where the different parts were supposed to go.



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 with Icon sets CC Excel Discussion (Misc queries) 4 April 21st 10 03:34 PM
Using icon sets with relative references parmstrong Excel Worksheet Functions 0 January 25th 10 06:11 PM
if, then, else with Excel 2007 icon sets bikierguy Excel Discussion (Misc queries) 1 January 2nd 09 01:53 AM
Referencing Icon Sets BLR Excel Worksheet Functions 3 December 4th 08 03:07 PM
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 01:35 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017