Apply Conditional Formatting to Shapes in Excel




About this tutorial:

Video duration: 5:43
Learn 2 ways to apply conditional formatting to shapes in Excel.

This technique is great for dashboards and interactive reports where you don’t want to be confined to the grid layout of the cells.

There is no way to actually apply conditional formatting to shapes in Excel, so both these methods are workaround solutions.

Here is the link to the article and page where you can download the sample Excel file:

Method #1: A simple solution is to copy and past e the cell that contains conditional formatting as a Linked Picture. …

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

19 thoughts on “Apply Conditional Formatting to Shapes in Excel

    Jihad Kibbi

    (August 19, 2019 - 5:20 am)

    Many thanks!…  that helps a lot.

    The Mad Paddler

    (August 19, 2019 - 5:20 am)

    The "Paste Linked Picture" cannot work on a different tab. I copied a cell from one tab, then went to another tab to paste – but the option for "Linked Picture" did not pop up. Is there a workaround?

    Farooq Khan

    (August 19, 2019 - 5:20 am)

    hi Mr jon can you tell me how i create cf shape options in excel. i see this video you have more options in excel book. please tell me how it possible. thanks.

    truglis555

    (August 19, 2019 - 5:20 am)

    Thanks! Gonna use it in a controlpanel as a overlay on a picture of my flat, with macroes that send webhooks. An use this as a status indicator.

    SANJAY KUMAR

    (August 19, 2019 - 5:20 am)

    Your videos really help full. Please advise, how to change a specific shap outline color based on some farmula or condition or custom formatting

    chaitanya avinash Thiparani

    (August 19, 2019 - 5:20 am)

    HELLO JOHN,THANKS FOR ALL THE HELPFULL VEDIOS.CAN WE DO THE SAME IN GOOGLE SHEETS ?PLEASE HELP ME OUT.REGARDS,AVINASH

    arif ahmed

    (August 19, 2019 - 5:20 am)

    how to change color with Number change ?? plz share!

    Pushpa Gulahe

    (August 19, 2019 - 5:20 am)

    Hey Jon, could you please help for how did you create the shape and what is link picture

    Doug H

    (August 19, 2019 - 5:20 am)

    Great tip with the format shape option.

    Edwin Montero

    (August 19, 2019 - 5:20 am)

    Hey Jon great job, Do you have an email address where one can contact you? Do you give some Excel's courses?

    Joseph Anglim

    (August 19, 2019 - 5:20 am)

    This is great! Thanks!

    Cliford Francillon

    (August 19, 2019 - 5:20 am)

    thank you! that helps a lot

    SC

    (August 19, 2019 - 5:20 am)

    Hi Jon, I noticed the selector is green color , can you help me how set up like that ? Thanks.

    Ravi Dhiman

    (August 19, 2019 - 5:20 am)

    Hi Jon I have one query here.
    I have one data where we have to meet the accuracy of 93% every month. So i used to send audit projections on the basis of number of audits on a daily to basis to meet the accuracy of 93%. Is there any way so that i can change the color of a cell which has <93% to red and >93% to green using conditional formatting, otherewise i am selecting color manually to each and every box.

    Please help.

    Lakesha Miller

    (August 19, 2019 - 5:20 am)

    hey Jon, thanks for the video. I am looking to change a excel sheet with conditional formatting where the colors are changing. but I want to do something a little different. for instance I want to change a number to a pie. Example if the number is 1 the pic in that cell would be a fourth of a sphere. if it is 2 it would show half a pie. if it is 3 3/4 of a pie and then for would show the whole pie. is that formatting available in excel if so what is it called. and how can I set it up for my spread sheet with our having a separate chart. I would like each individual cell to be a chart per say. I hope I made sense here.  thanks for your help in advance!

    NIRANJAN K M

    (August 19, 2019 - 5:20 am)

    Hey Jon – That was a great and an Informative data.
    Can you help me with the links on Macro if there are any.

    Excel.i Adam

    (August 19, 2019 - 5:20 am)

    Awesome conditional formatting 🙂

    Derek Lowry

    (August 19, 2019 - 5:20 am)

    simple but effective.. thanks

    From Nippon من اليابان

    (August 19, 2019 - 5:20 am)

    Thank you so much!

Leave a Reply

Your email address will not be published. Required fields are marked *