| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alowing a cell to change a picture
Good morning, i have a situation where i have a conditional format to do a
traffic light, but i want to use the same data to manipulate arrows in the adjacent cell, this will point up when red, right when green and left when Amber. Can this be done? How do i do that if it is possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Alowing a cell to change a picture
You can use the Wingdings 3 font to make arrows. Here is a very simply
example: =IF(A1A2,"#",IF(A1<A2,"$",2)) and format to Wingdings 3 just use the same test in the formula as you use in the conditional format. -- Gary''s Student - gsnu200781 "whatzzup" wrote: Good morning, i have a situation where i have a conditional format to do a traffic light, but i want to use the same data to manipulate arrows in the adjacent cell, this will point up when red, right when green and left when Amber. Can this be done? How do i do that if it is possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
| picture size can not change to web quality | Excel Discussion (Misc queries) | |||
| How to change an excel sheet into a picture? | New Users to Excel | |||
| How do I change default picture size | Excel Discussion (Misc queries) | |||
| how do i change excel into picture format | New Users to Excel | |||
Linear Mode
