Not exactly. I want the formatting to basically apply to the whole sheet so that when I select k-1 or w/h from the drop down in column a of any row, it will look like either row 3, 4, or 5 depending on which one i select. Does that make sense? Right now I have the 3 rows formatted separately but I beleive I would need to combine them and then apply that to the whole sheet. Please let me know what you think.