Highlight yellow where stock is Zero
While stock on others on the same line are greather than Zero
In the Attached file I have done those manually
Macro to read data at 25,ooo rows
If the rest of the Zero can be pink , It will be good ,
Since Conditional formatting not doing that because some
of Zero Stock is in Yellow
Use this:
Please Login or Register to view this content.
Last edited by alansidman; 11-07-2015 at 11:48 AM.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Alansidman , thank you almost
Half way through , remaining yellow highlights on stock
where is 0 if stock in same line exists
Expecting following cells to be Yellow
06
L14
S16
L19
S26
E35
E37
E38
E39
O36
O38
040
I have amended the code. If I understood correctly, where yellow, stays yellow.
No Yellow needs to be done by macro
It will be long to do that for 10,000 rows , one by one
I'm not sure I understand the rationale/criteria for the yellow highlights.
I am leaving the thread open , for someone to add on your macro the half of the program
Hi makinmomb
I have no idea how fast this Code will run on 10's of Thousands of records but it appears to do as you require. Ctrl + x will fire the Code.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thank you very much Jaslake ,
I have 6o,ooo rows to work on
I tested the data on 1000 rows , and working , wow , as exactly the way I want it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks