💻 Software
Excel - conditional formatting in Shapes?
Fresh7 days ago
Mar 15, 202621713 viewsConfidence Score0%
0%
Problem
For a long time, I didn't think it was possible to have a Shape (e.g., Text Box) have a value set by formula, but it turns out you can. Similarly, it appears that you can't apply conditional formatting to Shapes (the option is grayed out in the Ribbon in Excel 2007); is there some secret way to wor…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel - conditional formatting in Shapes?
Low Risk
No, but you can fake it You can fake it but it takes some setup. It will work unless you need really big shapes. Here are the steps for creating n different conditional format shapes in Excel 2010. tl;dr Use 1 extra cell and 1 text box for every con…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix