Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex conditional formatting
I have the following problem trying to set cell color based on conditional
parameters. I have a large spreadsheet where I do a log transform to get a result. Because of the formula, I lose the sign of the function. The columns look like this: Number1 Number2 Formula_Result a l x b m y c n z I want to conditionally format the cells in the Formula_Result column RED if Number1Number2, and GREEN if Number1<Number2. I'm stuck. I can do an individual cell, but can' figure out how to do that to the entire column. Just to be clear the result of comparing "a" and "b" control formatting of 'x', the result of comparing "b" and "c" control formatting of "y", etc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex conditional formatting
Brian
You can conditionally format an entire column just as you would a single cell. Click on cell c2, highlight column C; then Format Conditional Formatting Condition 1, formula is =A2B2 then your red format Condition 2, formula is =B2A2 then your green format If they are equal they will pick up the default format, that is whatever you make the column format. I assume your final "clarifying" sentence was incorrect since it seems to conflict with you initial statement. Good luck. Ken On Nov 11, 4:02*pm, Brian_M wrote: I have the following problem trying to set cell color based on conditional parameters. I have a large spreadsheet where I do a log transform to get a result. Because of the formula, I lose the sign of the function. The columns look like this: Number1 *Number2 *Formula_Result a * * * * * * * * *l * * * * * * * * * x b * * * * * * * * *m * * * * * * * * y c * * * * * * * * *n * * * * * * * * *z I want to conditionally format the cells in the Formula_Result column RED if Number1Number2, and GREEN if Number1<Number2. I'm stuck. I can do an individual cell, but can' figure out how to do that to the entire column. Just to be clear the result of comparing "a" and "b" control formatting of 'x', the result of comparing "b" and "c" control formatting of "y", etc. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Complex conditional formatting
" wrote: Brian You can conditionally format an entire column just as you would a single cell. Click on cell c2, highlight column C; then Format Conditional Formatting Condition 1, formula is =A2B2 then your red format Condition 2, formula is =B2A2 then your green format If they are equal they will pick up the default format, that is whatever you make the column format. I assume your final "clarifying" sentence was incorrect since it seems to conflict with you initial statement. Good luck. Ken On Nov 11, 4:02 pm, Brian_M wrote: I have the following problem trying to set cell color based on conditional parameters. I have a large spreadsheet where I do a log transform to get a result. Because of the formula, I lose the sign of the function. The columns look like this: Number1 Number2 Formula_Result a l x b m y c n z I want to conditionally format the cells in the Formula_Result column RED if Number1Number2, and GREEN if Number1<Number2. I'm stuck. I can do an individual cell, but can' figure out how to do that to the entire column. Just to be clear the result of comparing "a" and "b" control formatting of 'x', the result of comparing "b" and "c" control formatting of "y", etc. No, the latter is what I really mean. if B2A2, C2 is RED, if B2<A2, C2 is GREEN if B3A3, C3 is RED, if B3<A3, C3 is GREEN if B4A4, C4 is RED, if B4<A4, C4 is GREEN .... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex Conditional Formating | Excel Worksheet Functions | |||
Complex Conditional | Excel Worksheet Functions | |||
Complex conditional formatting | Excel Worksheet Functions | |||
complex conditional format | Excel Discussion (Misc queries) | |||
complex?? Q about Conditional formatting | Excel Worksheet Functions |