[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1852
  • Last Modified:

Excel VBA Conditional Formatting Shapes

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
shieldsco
Asked:
shieldsco
  • 2
  • 2
1 Solution
 
Ken ButtersCommented:
I've added VBA code to "Sheet1" that modifies the color according to the last row of data.
Q-28415771.xlsm
0
 
shieldscoAuthor Commented:
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
 
Ken ButtersCommented:
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
 
shieldscoAuthor Commented:
Very Good -- Thanks
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now