I've searched and tried the replies of several other posts, but they don't work. I need 4 cells to format gray with bold text(I know how to change this part) if the 2nd cell in the line of 4 cells contains a specific text, for example: B1, B2, B3, and B4 all need formatted if B2=maintenance, or administration, or one of several other options. I need this for a whole sheet for each row, but only those four cells per row. The only columns that will contain the text is column C and column H, if that helps. Everything I have tried turns the whole page formatted.
Bookmarks