Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells. For Excel nerds? :-)
I am trying to place a picture (a country flag) behind some cells to indicate
which country is reporting the numbers. When choosing "Format picture" I am setting the color to "washout". Then I am chossing "send picture to back" in order to make the numbers in the cell visible, but this does not work. I am using Excel 2003. Thank you for helping. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells. For Excel nerds? :-)
The only way I know to do this is to set up your data as it would normally
appear, ie in range A1:E7.........then select a similar sized area off to the right, say AA1:AE7 and put your flag images in the respective cells in that range,......then go back to the regular range and highlight it and using the CAMERA icon, take a picture of it and paste that picture over the Imaged range..........this is dynamic, so when you change the data in the original range, the Imaged range data will follow..... hth Vaya con Dios, Chuck, CABGx3 "Martin" wrote: I am trying to place a picture (a country flag) behind some cells to indicate which country is reporting the numbers. When choosing "Format picture" I am setting the color to "washout". Then I am chossing "send picture to back" in order to make the numbers in the cell visible, but this does not work. I am using Excel 2003. Thank you for helping. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells. For Excel nerds? :-)
Dear Chuck.
Thank you for your reply. I understand mostly everything except the camera part. Where in the menu bar can I find this ICON? - Martin "CLR" skrev: The only way I know to do this is to set up your data as it would normally appear, ie in range A1:E7.........then select a similar sized area off to the right, say AA1:AE7 and put your flag images in the respective cells in that range,......then go back to the regular range and highlight it and using the CAMERA icon, take a picture of it and paste that picture over the Imaged range..........this is dynamic, so when you change the data in the original range, the Imaged range data will follow..... hth Vaya con Dios, Chuck, CABGx3 "Martin" wrote: I am trying to place a picture (a country flag) behind some cells to indicate which country is reporting the numbers. When choosing "Format picture" I am setting the color to "washout". Then I am chossing "send picture to back" in order to make the numbers in the cell visible, but this does not work. I am using Excel 2003. Thank you for helping. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells. For Excel nerds? :-)
If it's not on your toolbar........then right click on a toolbar and choose
CUSTOMIZE, then select the COMMANDS tab, and TOOLS category.......then scroll down till you find the CAMERA icon and drag it to a toolbar......... Vaya con Dios, Chuck, CABGx3 "Martin" wrote: Dear Chuck. Thank you for your reply. I understand mostly everything except the camera part. Where in the menu bar can I find this ICON? - Martin "CLR" skrev: The only way I know to do this is to set up your data as it would normally appear, ie in range A1:E7.........then select a similar sized area off to the right, say AA1:AE7 and put your flag images in the respective cells in that range,......then go back to the regular range and highlight it and using the CAMERA icon, take a picture of it and paste that picture over the Imaged range..........this is dynamic, so when you change the data in the original range, the Imaged range data will follow..... hth Vaya con Dios, Chuck, CABGx3 "Martin" wrote: I am trying to place a picture (a country flag) behind some cells to indicate which country is reporting the numbers. When choosing "Format picture" I am setting the color to "washout". Then I am chossing "send picture to back" in order to make the numbers in the cell visible, but this does not work. I am using Excel 2003. Thank you for helping. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells. For Excel nerds? :-)
Thank you - now I found the camera. However, the problem is still the same =
I still can only see either the picture or the numbers in the cells, and not the numbers with the picture in the background. I am aware that I may need to selecet "Send picture to the back" but this does not work. P.S. Are you Spanish? "CLR" skrev: If it's not on your toolbar........then right click on a toolbar and choose CUSTOMIZE, then select the COMMANDS tab, and TOOLS category.......then scroll down till you find the CAMERA icon and drag it to a toolbar......... Vaya con Dios, Chuck, CABGx3 "Martin" wrote: Dear Chuck. Thank you for your reply. I understand mostly everything except the camera part. Where in the menu bar can I find this ICON? - Martin "CLR" skrev: The only way I know to do this is to set up your data as it would normally appear, ie in range A1:E7.........then select a similar sized area off to the right, say AA1:AE7 and put your flag images in the respective cells in that range,......then go back to the regular range and highlight it and using the CAMERA icon, take a picture of it and paste that picture over the Imaged range..........this is dynamic, so when you change the data in the original range, the Imaged range data will follow..... hth Vaya con Dios, Chuck, CABGx3 "Martin" wrote: I am trying to place a picture (a country flag) behind some cells to indicate which country is reporting the numbers. When choosing "Format picture" I am setting the color to "washout". Then I am chossing "send picture to back" in order to make the numbers in the cell visible, but this does not work. I am using Excel 2003. Thank you for helping. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells. For Excel nerds? :-)
Try this link for further information about the camera tool and how to
get it working in later versions of XL: http://www.j-walk.com/ss/excel/odd/odd04.htm Hope this helps. Pete |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format cells. For Excel nerds? :-)
Sorry, forgot to mention that once you have the picture of your data, then
Right-click on it and do FormatPicture ColorsAndLines FillColor = NoFill Lines = NoLines OK.............this will turn the background of the data picture transparent so you can see through it to see the flags in the cells behind. Nope, "Hienz 57" actually...... Vaya con Dios, Chuck, CABGx3 "Martin" wrote: Thank you - now I found the camera. However, the problem is still the same = I still can only see either the picture or the numbers in the cells, and not the numbers with the picture in the background. I am aware that I may need to selecet "Send picture to the back" but this does not work. P.S. Are you Spanish? "CLR" skrev: If it's not on your toolbar........then right click on a toolbar and choose CUSTOMIZE, then select the COMMANDS tab, and TOOLS category.......then scroll down till you find the CAMERA icon and drag it to a toolbar......... Vaya con Dios, Chuck, CABGx3 "Martin" wrote: Dear Chuck. Thank you for your reply. I understand mostly everything except the camera part. Where in the menu bar can I find this ICON? - Martin "CLR" skrev: The only way I know to do this is to set up your data as it would normally appear, ie in range A1:E7.........then select a similar sized area off to the right, say AA1:AE7 and put your flag images in the respective cells in that range,......then go back to the regular range and highlight it and using the CAMERA icon, take a picture of it and paste that picture over the Imaged range..........this is dynamic, so when you change the data in the original range, the Imaged range data will follow..... hth Vaya con Dios, Chuck, CABGx3 "Martin" wrote: I am trying to place a picture (a country flag) behind some cells to indicate which country is reporting the numbers. When choosing "Format picture" I am setting the color to "washout". Then I am chossing "send picture to back" in order to make the numbers in the cell visible, but this does not work. I am using Excel 2003. Thank you for helping. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why will my cells not format? | New Users to Excel | |||
How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
format cells dialog box does not come up | Excel Discussion (Misc queries) |