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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft.excel.training - Highlighting cells

microsoft.excel.training - Highlighting cells

ResolvedVersion Standard

Thu 13 Sep 2007, 16:54 Delegate James said...

James has attended:
Excel Intermediate course
Excel Advanced course

Highlighting cells

How do I highlight cells with a number over a certain value in a colour?

Tue 25 Sep 2007, 16:31 Trainer Anthony said...

RE: Highlighting cells

Hi James. You need to use conditional formatting to do this. Select your cell and then select Format - Conditional Formatting. This will bring up a dialog box in which you can specific the criteria you want to follow and the formatting change you want to occur.

Hope this helps,

Anthony

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

microsoft.excel.training - Highlighting cells

Highlighting cells

RE: Highlighting cells

Excel articles

Excel tip:

Editing Formulas in Excel Cells