Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting
|
|
|
The UK's most regular 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. |
Conditional formatting
Resolved · Low Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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
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.
|