I have a spreadsheet with a status column. The cells in that column
have conditional formatting, so that if the cell equals a value (In
Progress, Complete, Not Started, etc), it will have certain color
fonts and fill. I want the other adjacent cells in the same row to
have the same formatting. Maybe this can be accomplished using
conditional formatting with a formula or something. But I'm not sure
how to do that. Or maybe there is some other way. This would be the
equivalent to using the format painter to copy the formatting of the
one cell, over to the adjacent cells. I just want it to be automatic.

Any ideas?