| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional formatting based on numbers in columns
Hi, I would like to change the background color of a two cells (row by row) based on values in two other cells in the same row. If C10 AND if C1D1, the background color of cell A1 turns green and B1 turns red. but If C10 AND C1=D1, the background colors of both cells, A1 and B1 turn green. Ex: A B C D 1 Green Red 1 0 2 Green Green 12 12 3 No change in background color Thank you! -- Kind regards, Nic |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on positive/negative numbers | Excel Discussion (Misc queries) | |||
| Conditional function row formatting based on columns values being | Excel Discussion (Misc queries) | |||
| Conditional formatting based on max in range of other columns | Excel Worksheet Functions | |||
| Conditional Formatting Based of Cells Based on Data Entry in anoth | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Threaded Mode
