| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Icon set based on another cell
I have a row of information that I would like to check if they meet
certain criteria and then place a icon in the cell using conditional formatting. Currently my data is like thus: Material A Planned 1 jan 10 12 jan 10 26 jan 10 Shipped 12 Dec 09 17 Dec 09 23 Dec 09 What I would like to do is have a green icon if shipped is less than planned - 30, yellow icon if shipped is between planned - 30 and planned, red icon if = planned. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Icon set based on another cell
It's easiest to use conditional formatting to simply color certain cells red,
yellow or green. I don't think displaying on of three graphics is possible. -- * Please click Yes if this was helpful * Andy Smith Senior Systems Analyst Standard & Poor''s, NYC "NeoFax" wrote: I have a row of information that I would like to check if they meet certain criteria and then place a icon in the cell using conditional formatting. Currently my data is like thus: Material A Planned 1 jan 10 12 jan 10 26 jan 10 Shipped 12 Dec 09 17 Dec 09 23 Dec 09 What I would like to do is have a green icon if shipped is less than planned - 30, yellow icon if shipped is between planned - 30 and planned, red icon if = planned. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Setting an Icon Set conditional format for a single cell??? | Excel Discussion (Misc queries) | |||
| Merge cell icon is inactive | Excel Discussion (Misc queries) | |||
| Excel: want to have linked icon fit into cell for each row | Excel Discussion (Misc queries) | |||
| Looking up and displaying a icon based on a cell value | Excel Discussion (Misc queries) | |||
| Reveal cell formats and extendable range in tool/statusbar/icon. | Excel Worksheet Functions | |||
Linear Mode
