Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Resolved · Low Priority · Version 2003
Hello Hugo
Thank you for your question and welcome to the forum.
Generally, the steps are:
1. Select the cells you wish to apply conditional formatting to.
2. Go to Format - Conditional Formatting.
3. Set the condition/s that would trigger Excel to apply the formatting for you - you can set up to three conditions.
4. For each condition, click the adjacent Format button to set up the formatting that would be applied if there was a match to the condition.
5. Click OK.
Kind regards
Amanda
Wed 24 Jun 2009: Automatically marked as resolved.
|
Excel tip:Using Excel's MODE functionUse Excel's MODE function to display the most common value present in a particular range of cells. |
We'll call during UK business hours
Server loaded in 0.07 secs.