[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel VBA Conditional Formatting Shapes

Posted on 2014-04-18
4
Medium Priority
?
1,831 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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!
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
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…

872 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