Hi
I am using icons (traficlight) and conditional formatting. By default the icons are always shown left in the cell. Is there some way I change it so it will not be "Icon - number" in the cell but "number - icon"?
Say you are interested in A1
in B1 enter
=A1
Add an icon set to B1 and select Show Icon only
The icon now shows to the right of the original number (albeit in a new column)
Regards
Special-K
I rarely return to a problem once I've answered it so make sure you clearly define what the trouble is.
Thanks for your answer. I thought of it and already do it but it would have been nice with a quick fix so I could do it in some old reports that are about to be updated (using icons this time). I guess I can just learn to think two steps further when setting up a report :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks