Inherit formatting from adjacent cells

  • Thread starter Thread starter clarv02
  • Start date Start date
C

clarv02

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?
 
If your status column is column C, use conditional formatting with the
option:
Formula Is
=$C1="In Progress"

The $ for absolute reference means that the whole row (or as much of it as
you choose to apply the format) is formatted depending on the value in
column C.
 
David,

When I first tried this it appeared to not work. That's because I
didn't realize I needed quotes even when there is no space, as in
"Complete". Once I put the quotes in for all the conditions, it works
like a charm.

Thank you!!
 
Back
Top