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 Biddulph

"clarv02" wrote in message
oups.com...
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?

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!!


On Feb 5, 1:08 pm, "David Biddulph" wrote:
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 Biddulph

"clarv02" wrote in message

oups.com...



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?- Hide quoted text -

- Show quoted text -