98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting
Conditional formatting
Resolved · Low Priority · Version 2007
Wed 20 Jul 2011, 15:53
Edited on Wed 3 Aug 2011, 15:29Delegate Zoe said...
Zoe has attended:
Excel Intermediate course
Conditional formatting
In conditional formatting is there a way of making the icons closer to the data in the cell so it easier on the eye - without left aligning the cells?
Sorry - resolved I clicked on the wrong button
Fri 22 Jul 2011, 11:15Trainer Anthony said...
RE: conditional formatting
Hi Zoe, thanks for your query. I'm afraid you are stuck with the position of icons generated by conditional formatting - they are baked into the application and there is no way to really manipulate them.
Hope this helps,
Anthony
Wed 3 Aug 2011, 15:12
Edited on Wed 3 Aug 2011, 15:15Trainer Doug said...
RE: conditional formatting
Hi Zoe, there is work around to position icons to the right of data. But have to first copy data to adjacent column to right then edit the conditional formatting rule ticking 'Show Icon only'. Finally clear the conditional formatting for the original data. If the figures are likely to change could paste link into the adjacent column. Complicated but as Anthony said those icons are stuck unless you show icons only.
Doug
Wed 10 Aug 2011: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Creating custom listsIn Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc. |
