excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel

Excel

resolvedResolved · Low Priority · Version 2003

hugo has attended:
Excel Advanced course

Excel

How do I apply conditional formatting?

RE: Excel

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 function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

View all Excel hints and tips


Server loaded in 0.07 secs.