This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
If you're going to add more and more columns I would probably advise changing the table structure to have a new row for each location and product scenario and therefore one other column for status (3 columns in all), rather than your existing table which has a column for each product at a certain location which could get unwieldy very quickly. This would also make it much easier to manage your row level formatting.
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.
Thanks for the suggestion, but specific cell formatting is a requirement. You did give me an idea transpose the data as you suggested, build a batch macro on each column, and append the row header. Then append everything together using layout tools.
I'm not sure how robust it would be, but I did work through a bit of this. I tried out changing the formatting based on the cell value. I'm not an app expert, but it seems like you would have to create a bunch of dummy conditional formatting then use a text box, and the desired formatting (in my case background color).
Not the most elegant solution, but one that could be used in a pinch.