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.
|