Editing Formulae - Colored Cell Borders

hmyers · May 9th, 2002, 08:21 AM

When I want to see which cells are being picked up in a formula, usually I go to the cell, hit F2, and the linked cells are highlighted with a border that is color coded to the cell reference in the formula. Recently, however, I have come across instances where the colored borders do not appear. Does anyone know if this is due to some setting being disabled for the workbook, or for inidividual cells?

Juan Pablo González · May 13th, 2002, 12:47 AM

Not that I know of. I know that they will not appear if you use the Paste function wizard, for example.

May 13th, 2002, 12:47 AM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Not that I know of. I know that they will not appear if you use the Paste function wizard, for example. __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 08:21 AM	#1
hmyers New Member Join Date: May 2002 Posts: 8	When I want to see which cells are being picked up in a formula, usually I go to the cell, hit F2, and the linked cells are highlighted with a border that is color coded to the cell reference in the formula. Recently, however, I have come across instances where the colored borders do not appear. Does anyone know if this is due to some setting being disabled for the workbook, or for inidividual cells?