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 » Conditionally Formatting Linked Cells

Conditionally Formatting Linked Cells

ResolvedVersion 2007

Wed 22 Oct 2008, 08:39 Delegate Michael said...

Michael has attended:
Word Advanced course

Conditionally Formatting Linked Cells

Is there a way to use conditional formatting on cells that contain links?

For example:

1. Cell with links to other sheets - fill blue.
2. Cell with link to other cells on sheet - fill green.

Thu 23 Oct 2008, 17:54 Trainer Laura said...

RE: Conditionally Formatting Linked Cells

Hi Micheal

Thank you for the question.

Unfortunately I cannot find a method of creating a rule to examine what a formula contains. Excel 2007 has added lots of features to conditional formatting but it has not included that one.

I would reaqlly like someone to prove me wrong as I can see lots of uses for it.

Regards

Laura GB

Excel tip:

Creating charts in Excel 2010

Here's how to present your data in a chart format:

Highlight the data you wish to use in a chart

Click the Insert Ribbon

In the Charts Group, select Column Chart

Your chart will then appear on your work sheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Conditionally Formatting Linked Cells

Conditionally Formatting Linked Cells

RE: Conditionally Formatting Linked Cells

Excel articles

Excel tip:

Creating charts in Excel 2010