Solved

Excel VBA Conditional Formatting Shapes

Posted on 2014-04-18
4
1,694 Views
Last Modified: 2014-04-19
I have 3 oval shapes on an Excel worksheet that I want to conditionally format base on the %_Resolved below. If the % Resolved in the last month (in this case Apr - note: a new month gets added each month) >= 95% then Green Else Yellow.



Month             %_Resolved
Oct            63%
Nov            19%
Dec            19%
Jan            95%
Feb            98%
Mar            98%
Apr            91%
Year-to-date      70%
0
Comment
Question by:shieldsco
  • 2
  • 2
4 Comments
 
LVL 19

Expert Comment

by:Ken Butters
ID: 40009432
I've added VBA code to "Sheet1" that modifies the color according to the last row of data.
Q-28415771.xlsm
0
 

Author Comment

by:shieldsco
ID: 40009497
I have 3 oval shapes on an Excel worksheet that I want to conditionally format base on the %_Resolved below. I attached my spreadsheet with the VBA in it. I do not think it's working correctly for my situation
Test.xlsm
0
 
LVL 19

Accepted Solution

by:
Ken Butters earned 500 total points
ID: 40009668
Looks like your 3 different ovals are conditioned based on 3 different pivot tables.

I've updated the code to check the various conditions in the pivot tables and color the associated shapes accordingly.
Test.xlsm
0
 

Author Closing Comment

by:shieldsco
ID: 40010313
Very Good -- Thanks
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question