Coloring rows of cells
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. |
Coloring rows of cells
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 " wrote in message oups.com: 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. |
Coloring rows of cells
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 JimMay wrote: 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 " wrote in message oups.com: 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. |
All times are GMT +1. The time now is 02:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com