I would like to place a colored circle in cell E5 and be able to display E5 in another cell if the circle is indeed in E5. Is this possible? Is there perhaps another way of doing this? I know I could use an X instead of a circle but it is not the greatest choice.
Last edited by VBA Noob; 11-10-2007 at 03:11 AM.
Not quite sure what you are trying to do, but try this....select E5, go to Insert > Symbol and pick a circle > OK. Increase the font size and colour if need be. Then in G5 type this
=IF(E5="","",E5)
Does that help?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks