Links to my spreadsheet
Pre
https://drive.google.com/file/d/1fQs...ew?usp=sharing
Final Product
https://drive.google.com/file/d/1Msm...ew?usp=sharing
I've almost fully coded the vba to achieve my desired results but I'm not sure how to conditionally format with VBA.
I want to conditionally format the spreadsheet. Highlighting full rows where sold IS NOT = 0 in green, individual cells where % distant is greater than 50% in yellow, and last disposition is over 1 hour earlier than the max time of the last disposition row also in yellow.
Please help. The code I have so far is below
Please Login or Register to view this content.
Bookmarks