Coloring rows of cells

G

goldcomac

My worksheet has names in column A and numbers in B2:F78. If the total
in row B80, or C80, or D80, etc., equals 20, I would like to highlight
the entire row a color. It's possible that B80 & D80 & E80 = 20, but
the others don't.

Is that possible?

Thanks.
 
J

JimMay

Click on the row header of row 80,
Then Format, C/F - FormulaIs and enter:
=OR($B80=20,$D80=20,$E80=20)
Select pattern color
OK
 
G

goldcomac

This isn't what I'm looking for. If cell 80 = 20 in column B, I am
trying to get all of column B to turn grey. Same thing for column C, E,
& F. But, if column C doesn't = 20, then I don't what that column to
turn any color. It stays at the default until it reaches 20.

Chip
 
Top