VBA to color the object with criteria and condition

Hello,

I have a draw object in excel and I wonder if there is an automatic vba that help me color an object red when cell B14 in a range of -10% to -20% or we can do formula if it is necessary. In addition, I want to be able to display value of cell B14 in the center of the object as well. Thanks.

Hi tantcu,

VBA can do it quite easily, but we would need a few more details (such as a sample workbook) for that.

Before you go the VBA route, take a look at CONDITIONAL FORMATTING, which will probably do the job better for you:http://office.microsoft.com/en-us/ex...010370614.aspx

Lewis

Hi,

I understand about conditional formatting and in this case I won't need to use it. I attached a sample in this. For example, if the Texas object is in range 10% - 14% I want it to automatically turn to green and if it is lower than 10 % then apply another condition and turn it to yellow. Please let me know if this is possible since I have to this for 50 states.Test vba on object.xlsx

Very interesting and fun project.

See the attached file (your file modified) which will get you started (written and tested in Excel 2003).
1. The file will allow you to:
a. Color each state as you requested.
b. Insert the percentage in the center of each state.

2. There are instructions and Macros to:
a. Add states (and assign names (e.g. 'CA' for California) to each State shape.
b. Adjust the centering of Percentage Text (e.g. Florida probably needs adjusting).
c. Various other capabilities which are explained in the file.

Please let me know if there's anything else you need.

Lewis