| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting based on numbers in columns
Condition formula for Column A: =AND(C10,C1=D1) Condition formula1 for Column B: =AND(C10,C1D1) red =AND(C10,C1=D1) green Regards, Stefi €˛Nic Daniels€¯ ezt Ć*rta: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting based on numbers in columns
Hi, For you first condition apply this to A1 and select Red =AND(C10,C1D1) Click ADD and apply this second condition to A1 and choose Green =AND(C10,C1=D1) Repeat the above for B1 choosing the appropriate colours. Mike "Nic Daniels" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting based on numbers in columns
Thank you! -- Kind regards, Nic "Stefi" wrote: Condition formula for Column A: =AND(C10,C1=D1) Condition formula1 for Column B: =AND(C10,C1D1) red =AND(C10,C1=D1) green Regards, Stefi €˛Nic Daniels€¯ ezt Ć*rta: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting based on numbers in columns
Thank you! -- Kind regards, Nic "Mike H" wrote: Hi, For you first condition apply this to A1 and select Red =AND(C10,C1D1) Click ADD and apply this second condition to A1 and choose Green =AND(C10,C1=D1) Repeat the above for B1 choosing the appropriate colours. Mike "Nic Daniels" wrote: 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional formatting based on numbers in columns
You are welcome! Thanks for the feedback!
Stefi €˛Nic Daniels€¯ ezt Ć*rta: Thank you! -- Kind regards, Nic "Stefi" wrote: Condition formula for Column A: =AND(C10,C1=D1) Condition formula1 for Column B: =AND(C10,C1D1) red =AND(C10,C1=D1) green Regards, Stefi €˛Nic Daniels€¯ ezt Ć*rta: 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 |
| Reply |
| 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 | |||
Linear Mode
