Formatting Issues

Why Excel Linked Pictures Lose Conditional Formatting After Place in Cell

Maira Mehtab Sep 24, 2026 869 views

Question details

The user wants to keep conditional formatting updates on linked pictures after placing them inside a cell, which is currently breaking the link.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a grading or stoplight system that uses multiple dynamically updating linked images based on conditional formatting rules.
Observed behavior: When using the 'Place in Cell' feature on a linked picture, Excel breaks the link to the source cell, preventing future conditional formatting updates.

Before you start

Understand that spreadsheet software treats floating objects and in-cell data differently; placing a dynamic image inside a cell converts it to a static value.

Solution 1Recommended

Keep the Picture as a Floating Linked Image

Retain the dynamic link to the source cell by leaving the picture floating rather than embedding it directly into the cell.

This is an inherent limitation in Excel: a picture cannot simultaneously be a linked dynamic object and an in-cell image. When you use the 'Place in Cell' feature, the software permanently removes the link to the original cell.

To keep conditional formatting dynamic, the image must remain floating over the spreadsheet grid.

Copy the source cell

Select the cell that contains the conditional formatting you want to display, then press Ctrl + C to copy it.

Paste as a Linked Picture

Right-click the destination area, hover over 'Paste Special', and select the 'Linked Picture' icon.

Align manually over the cell

Drag the linked picture to align it perfectly over your target cell without using the 'Place in Cell' option.

Linking Limitation: Because the image is floating, it will not automatically filter or sort perfectly alongside cell data unless you adjust the object properties to 'Move and size with cells'.

Solution 2

Use VBA Macros to Bulk Resize Linked Images

If you have hundreds of linked images for a grading or stoplight system, use a macro to size and align them automatically instead of using Place in Cell.

Free Microsoft Office alternative

Switch to WPS Office for a Smoother Spreadsheet Experience

If you frequently encounter limitations with complex formatting and object management in Microsoft Excel, consider trying WPS Office. It provides a lightweight, highly compatible, and free alternative to expensive Office subscriptions, making it easier to manage large datasets and grading systems.

1. Download the software: Visit the official WPS Office website to download the free installation package.
2. Install WPS Office: Run the installer and follow the simple on-screen instructions to set up the software.
3. Open your workbook: Launch WPS Spreadsheet and open your existing .xlsx file to continue managing your linked images without hassle.

Fully compatible with Microsoft Excel (.xlsx) formats, formulas, and conditional formatting rules.Lightweight installation with incredibly fast startup times.Familiar tabbed interface makes transitioning seamless and intuitive.Completely free to use for everyday complex spreadsheet tasks.

microsoft office alternative - wps office

Frequently Asked Questions

What happens when I use Place in Cell on a linked picture?

When you use the 'Place in Cell' feature, the spreadsheet converts the floating object into a static cell value. This completely breaks the dynamic link to the source cell, meaning any conditional formatting changes will no longer update on the image.

Can an image be both an in-cell image and a linked picture at the same time?

No, this is a known software limitation. An image must either be a floating linked picture that updates dynamically or a static image embedded into a cell.

How do I fix multiple broken linked pictures in my grading system?

There is no quick fix to restore links once 'Place in Cell' is applied. You must undo the action or recreate the linked pictures and keep them floating. To manage them easily, you can use a VBA macro to perfectly align them over the cells.

How can I make floating linked pictures move when I sort data?

Right-click the floating linked picture, select 'Size and Properties', and under the Properties tab, check the option for 'Move and size with cells'. This will ensure the image stays with its underlying cell when data is sorted or filtered.

Document & File Issues