Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Blank Rows from Merged Cells in Drop Down Menu | Excel Discussion (Misc queries) | |||
identically size merged cells for sorting rows | Excel Discussion (Misc queries) | |||
sort 2 or more rows of cells linked to one row of data | Excel Worksheet Functions |