I have a spreadsheet that I would like to format based on the selection in column A from a drop down menu. I have been able to format lines 3-5 how I would like the line to appear once a selection has been made. But I would like to utilize the formulas for all the rows. My issue is that there are basically 3 different options of what a row could look like, how do i merge that so that each row can potentially look 3 ways depending on the dropdown.
Copy of Sample WH Template v2 (3) (2).xlsx
Thanks in advance!
Bookmarks