Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format a column based on value in a different column
How can I conditionally format (highlight) some cells in column E based on
the values in column C of the same row? I have no trouble highlighting a column based on it's values, but I need to highlight the cells in a column based on the values in a different column but the same row. Example: If C1 is negative, highlight E1 in red. If C2 is positive, highlight E2 in green. If C6 = "B", highlight E6 in yellow, etc. I'm having trouble having the value/formula in conditional formatting refer to a different cell, but cannot specify a specific cell for all rows, if that makes sense. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format based on a different column | Excel Worksheet Functions | |||
Conditional format row based on 1 column. | Excel Discussion (Misc queries) | |||
conditional format on column based on cell value | Excel Worksheet Functions | |||
Conditional format based on data from another column | Excel Discussion (Misc queries) | |||
Conditional Format a column based on another | Excel Discussion (Misc queries) |