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 » Conditionally Formatting Linked Cells
Resolved · High Priority · Version 2007
Michael has attended:
Word Advanced course
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.
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:Changing the Tab Colour of an Excel 2010 WorksheetDid you know you could give the tabs in your worksheet different colours? |
We'll call during UK business hours
Server loaded in 0.08 secs.