Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format based on other cells
I can use conditional formatting to change the shading dependent on it's value.
How can I do conditional formatting based upon another cell. e.g. I want to shed column D dependent on the value in column C. Any suggestions ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format based on other cells
Change the "Cell Value Is" to "Formula Is" then enter:
=C1=100 When placed in Column D, this will shade column D if C1 = 100. You may use any formula that evaluates to TRUE or FALSE. So, something like this would also work: =OR(AND(C10,C1<100),A1="ABC") This will shade the cell if C1 is greater than 0 and less than 100, or cell A1 contains the text string "ABC". HTH, Elkar "Tonto" wrote: I can use conditional formatting to change the shading dependent on it's value. How can I do conditional formatting based upon another cell. e.g. I want to shed column D dependent on the value in column C. Any suggestions ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format based on other cells
Similar question: I have only 4 values that are displayed in Column C and
each one needs to have it's own color in Column A. How do I set a formula to include the corresponding cells for an entire column? Only Column A needs to be formatted. "Elkar" wrote: Change the "Cell Value Is" to "Formula Is" then enter: =C1=100 When placed in Column D, this will shade column D if C1 = 100. You may use any formula that evaluates to TRUE or FALSE. So, something like this would also work: =OR(AND(C10,C1<100),A1="ABC") This will shade the cell if C1 is greater than 0 and less than 100, or cell A1 contains the text string "ABC". HTH, Elkar "Tonto" wrote: I can use conditional formatting to change the shading dependent on it's value. How can I do conditional formatting based upon another cell. e.g. I want to shed column D dependent on the value in column C. Any suggestions ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional format based on other cells
I aslo have a multiple conditional format question.
I would like to format rows based on a value being found anywhere in a 4 column by 84 row array. Thanks, Lee "Jamie" wrote: Similar question: I have only 4 values that are displayed in Column C and each one needs to have it's own color in Column A. How do I set a formula to include the corresponding cells for an entire column? Only Column A needs to be formatted. "Elkar" wrote: Change the "Cell Value Is" to "Formula Is" then enter: =C1=100 When placed in Column D, this will shade column D if C1 = 100. You may use any formula that evaluates to TRUE or FALSE. So, something like this would also work: =OR(AND(C10,C1<100),A1="ABC") This will shade the cell if C1 is greater than 0 and less than 100, or cell A1 contains the text string "ABC". HTH, Elkar "Tonto" wrote: I can use conditional formatting to change the shading dependent on it's value. How can I do conditional formatting based upon another cell. e.g. I want to shed column D dependent on the value in column C. Any suggestions ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format based on other cell's value | Excel Worksheet Functions | |||
Conditional format in merged cells. | Excel Discussion (Misc queries) | |||
Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
Calculate percentage based on cells with conditional formatting | New Users to Excel | |||
How do I set a Conditional Format for ROWs based on the value of . | Excel Discussion (Misc queries) |