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 2011 (Mac)
Reply Tue 25 Oct 2011, 16:02Delegate Christine said...
Christine has attended:
Excel Intermediate course
Excel Advanced course
Conditional formatting
how do i make formatting consistence
For upcoming training course dates see: Pricing & availability
RE: conditional formatting
Hi Christine
Thank you for your question. To make sure your conditional formatting behaves consistently select the cells which have your formatting applied to them and from the Home ribbon choose Conditional formatting > Manage rules. Click the active formatting rule and choose edit. Check the criteria Excel is using to trigger the conditional formatting. Many use a percentage of the total to drive the various formats and you may prefer to change the thresholds or switch from percentages to numbers.
I hope this helps - do let me know if you have any further questions.
Kind regards,
Andrew
Tue 1 Nov 2011: Automatically marked as resolved.
|