Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting question
if column_a changes the color, i want column_b change to the same color. how
can i do that? thx. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting question
If the color in column A is being changed by conditional formatting, set up
the same condition in the column B cell, but referencing column A (use Formula Is instead of Cell Value Is). For example, lets say you set up a conditional format for Cell A2 that says if its value is 5, set the background as Red. Then in B2 we'd set up conditional format as Formula Is and enter =$A$2=5 and set the background color to Red also. "JJ" wrote: if column_a changes the color, i want column_b change to the same color. how can i do that? thx. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting question
where is "formula is"? thx.
"JJ" wrote: if column_a changes the color, i want column_b change to the same color. how can i do that? thx. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting question
It is in the drop down list when you first start Conditional Formatting. It
is initially displayed as [Cell Value Is] followed by something like "between" and a couple of data entry boxes. Just click the arrow on the [Cell Value Is] and you'll see [Formula Is] and the rest of the form will change based on that. "JJ" wrote: where is "formula is"? thx. "JJ" wrote: if column_a changes the color, i want column_b change to the same color. how can i do that? thx. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting question
Hi,
let me make it more clear: my 2 column is like this, col_a is numbers, col_b is percentage, if cells in col_b bigger than 30%, i want to change cells in col_a's color to pink. Would you help me, btw, i am using 2007. thx. "JLatham" wrote: If the color in column A is being changed by conditional formatting, set up the same condition in the column B cell, but referencing column A (use Formula Is instead of Cell Value Is). For example, lets say you set up a conditional format for Cell A2 that says if its value is 5, set the background as Red. Then in B2 we'd set up conditional format as Formula Is and enter =$A$2=5 and set the background color to Red also. "JJ" wrote: if column_a changes the color, i want column_b change to the same color. how can i do that? thx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Question | Excel Discussion (Misc queries) | |||
Another conditional formatting question. | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Worksheet Functions | |||
Conditional Formatting question | Excel Worksheet Functions | |||
Conditional formatting question | Excel Worksheet Functions |