Excel Conditional Formatting functions - apply rules to Shapes from multiple conditions
 
See more Excel Image Tools from MyExcelTools.com Website    
 
   

Create Excel Conditional Formatting with the Shapes creator Tool:

   
With This Excel Spreadsheet Image assistant Tool you can apply Conditional Formatting and display dynamic shapes or images from conditional formatting rules in cells (dynamic custom Shapes that contain Conditional Formatting rules)
On the first screen, you should indicate what type of shape you would like
You can choose between creating a 3-color Traffic light or choosing multiple-condition shape (for this case you must indicate your cells with the rules or decision table, that is, how to paint the shape according to the evaluated condition)
   
Manage and Apply Excel Conditional Formatting rules to Shapes from cell condition  
   
Manage and Apply Excel Conditional Formatting rules to Shapes from cell condition  
You can acces to this Excel shape & image tool dialog box from Excel image assistant menu in the ribbon toolbar option CF Shapes Creator.
Create Highlight shapes & images Based on the Value of Another Cell or apply some Conditional formatting rules to shapes or pictures.
   
     

Steps to create, use and manage Conditional Formatting rules with shapes in Spreadsheet cells.

   
Select the value for each of the rules or conditions    
1-Choose the range and color for the condition1    
2-Choose the range and color for the condition2    
3-Finally choose the cell that contains the value to evaluate    
You can change the value of the cell to evaluate to appreciate the changes in shape according to the format rules.    
In the same way, you can change the values ​​of the conditions (green and yellow to change the numerical range to be evaluated for each condition)    
The green and yellow rules represent ranges of values ​​or numerical ranges of data.    
You can make several copies of the shape, you can even change the type and size of shape and always keep the conditional format with respect to the indicated cell and condition.
You can Create or edit your own Conditional Formatting rules for Excel Shapes.
   
     

Create Excel conditional formatting forms with multiple rules or cell conditions

   
     
To create the shapes that work with multiple rules, you must choose the type of shape to be plotted, and the range you want to evaluate (everything is very similar to the way I use to create the traffic lights)
See more detail about Manage, Edit and create multiple Excel shapes rules or conditions with Conditional Formatting.
   
Manage and Apply Excel Conditional Formatting rules to Shapes from cell condition    
The only difference would be that you now need to first have a table of decisions of the conditional format rules that you want to apply After you construct your table of desitions with the conditions (> =, <=, = or <>) you must create a condition in each row of the decision table. Finally, from the dialog box, Conditional Formatting Shape Creator complete the data (Do not forget to select your complete decision table, that is, do not forget to include your headers with the symbols <=,> =, =, <>, etc)    
     

Manage, Edit and create multiple rules or conditions with Conditional Formatting Colors in Excel Shapes

   
With this picture tool you can Manage, Edit or create multiple rules or conditions with Conditional Formatting Colors in new Excel Shapes    
To edit or reset the colors for shapes with Excel conditional formatting: Click on the button with the text Edit Conditional Color for Shapes or click on the Reset Colors button to return the colors for the shape to the state colors by default.    
     
Manage, Edit, change or reset all Excel Conditional Formatting rules colors in Shapes from condition    
     
Note:    
This tool creates a hidden sheet to be able to make the connections between values ​​of cells and shapes. It is not necessary for you to make any changes to the UserShapeCell sheet    
This tool is not compatible with Excel 2007 because of differences in the object model and its methods. It works correctly Excel 2010, 2013, 2016 32 and 64 bits    
Excel does not allow to apply conditional formatting on shapes only on cells, so the tool performs the necessary processes to emulate a behavior of the shapes as if it were a conditional format However, the shapes have practically all the behavior of a cell with a conditional format when they are linked to a cell.    
You can share your Excel books and shapes with your collaborators without relying on any software on your colleagues' computer