Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with Icon sets | Excel Discussion (Misc queries) | |||
Using icon sets with relative references | Excel Worksheet Functions | |||
if, then, else with Excel 2007 icon sets | Excel Discussion (Misc queries) | |||
Referencing Icon Sets | Excel Worksheet Functions | |||
Additional Icon Sets | Excel Discussion (Misc queries) |