EXX-131011-Format-Shape.xlsm

<div>
Thank You Faustulus. This was perfect!<br />
<br />
All the Best !
</div>


Thank You Faustulus. This was perfect!

All the Best !

<div>
I'm really glad I hit this nail on the head. I was a bit worried because the subject is intricate. If you have any more questions while implementing you can come back here even after you closed the question officially.
</div>


I'm really glad I hit this nail on the head. I was a bit worried because the subject is intricate. If you have any more questions while implementing you can come back here even after you closed the question officially.

<div>
<div class="content wysiwyg-content">
Hello All,<br />
<br />
I have oval autoshapes in excel that I want to autoformat based on the text value in the shape or based on another cell value:<br />
<br />
IF value =&quot;A&quot;, shape color should be Amber, &quot;R&quot; to Red, &quot;G' to Green, &quot;C&quot; to Blue, and &quot;NS&quot; to grey<br />
<br />
I am very much a VB Excel novice and would appreciate any guidance.<br />
<br />
thanks in advance!
</div>
</div>


Hello All,

I have oval autoshapes in excel that I want to autoformat based on the text value in the shape or based on another cell value:

IF value ="A", shape color should be Amber, "R" to Red, "G' to Green, "C" to Blue, and "NS" to grey

I am very much a VB Excel novice and would appreciate any guidance.

thanks in advance!

Automformat Excel AutoShapes

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.