Hello,

I've written a conditional formatting rule that places a border around a row when the word "lunch" is typed into any cell in that row. However, each row consists of 3 cells and I want to remove the inside borders, i.e. the borders dividing the 3 cells within the row and have it just be one square box around the row itself. Excel does not seem to offer this as an option in Conditional Formatting. Does anyone have a workaround?

Thanks!