Okay, I'm back again. The previous question I've asked has been figured out by another coworker at a different store, but now I'd like to spice up his workbook. We have three issues and we are hoping for some help :
1) Would there be a way to set up a conditional formatting, or if it's too complex a formula or macro, to shade out a row?
---Column A can only equal Yes or No; if column A equals yes we would like the rest of the row (consisting of columns B-L) to be formatted to strikethrough so we can see that it is completed and no longer needs attention. We can't delete the lines due to documentation issues, so that easy scenario is out of the question.
2) We have 3 columns formulated to equal specific dates, with B being the date the item was added. So column C, for instance, would be set to =if(B="","",B+5). Would it be possible to set a conditional format to highlight the dates that need attention? For example, a unit is recieved on 12/4 and the customer is notified; five days later we would notify them again and we would like the date (if it equals todays date) to show up highlighted in red. We've already applying the formatting to cell value=today() but that obviously doesn't work. EDIT: WE GOT THIS ONE FIGURED OUT PRETTY DARN EASILY...DON'T KNOW WHAT I WAS THINKING
3) The last one is probably going to be hard to set up. My coworker realized today we quickly run out of rows and wants to avoid having a huge sheet if it's not neccesary. He's currently researching macros, which we both have no experience in. Would there be a way to set up a macro to add lines to a sheet once we have only two left?
I will upload a similar version of what we use, but I will avoid any associations with our company or industry. If you have any personal questions for clarification purposes just PM me and I'll be glad to discuss in private
Thank you so much and I greatly apologize for the length of my posts!
Bookmarks