Conditional format a column based on value in a different column
 

How can I conditionally format (highlight) some cells in column E based on
the values in column C of the same row?

I have no trouble highlighting a column based on it's values, but I need to
highlight the cells in a column based on the values in a different column but
the same row.

Example: If C1 is negative, highlight E1 in red.
If C2 is positive, highlight E2 in green.
If C6 = "B", highlight E6 in yellow, etc.

I'm having trouble having the value/formula in conditional formatting refer
to a different cell, but cannot specify a specific cell for all rows, if that
makes sense.


Thanks.

Conditional format a column based on value in a different column
 

1. Select the cell/Range (say E1:E10). Please note that the cell reference
E1 mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=C1<0
Click Format ButtonPattern and select your color (say Red)

4. Click on Add button.

5. For Condition2Select 'Formula Is' and enter the below formula
=C10
Click Format ButtonPattern and select your color (say Green)

6. Click on Add button.

7. For Condition3Select 'Formula Is' and enter the below formula
=C1="B"
Click Format ButtonPattern and select your color (say Yellow)

8. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Friday" wrote:

How can I conditionally format (highlight) some cells in column E based on
the values in column C of the same row?

I have no trouble highlighting a column based on it's values, but I need to
highlight the cells in a column based on the values in a different column but
the same row.

Example: If C1 is negative, highlight E1 in red.
If C2 is positive, highlight E2 in green.
If C6 = "B", highlight E6 in yellow, etc.

I'm having trouble having the value/formula in conditional formatting refer
to a different cell, but cannot specify a specific cell for all rows, if that
makes sense.


Thanks.

Conditional format a column based on value in a different colu
 

What took you so long Jacob? It was almost 5 minutes before I received your
answer! (lol) Many thanks.

"Jacob Skaria" wrote:

1. Select the cell/Range (say E1:E10). Please note that the cell reference
E1 mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=C1<0
Click Format ButtonPattern and select your color (say Red)

4. Click on Add button.

5. For Condition2Select 'Formula Is' and enter the below formula
=C10
Click Format ButtonPattern and select your color (say Green)

6. Click on Add button.

7. For Condition3Select 'Formula Is' and enter the below formula
=C1="B"
Click Format ButtonPattern and select your color (say Yellow)

8. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Friday" wrote:

How can I conditionally format (highlight) some cells in column E based on
the values in column C of the same row?

I have no trouble highlighting a column based on it's values, but I need to
highlight the cells in a column based on the values in a different column but
the same row.

Example: If C1 is negative, highlight E1 in red.
If C2 is positive, highlight E2 in green.
If C6 = "B", highlight E6 in yellow, etc.

I'm having trouble having the value/formula in conditional formatting refer
to a different cell, but cannot specify a specific cell for all rows, if that
makes sense.


Thanks.

Conditional format a column based on value in a different colu
 

Cheers..

If this post helps click Yes
---------------
Jacob Skaria


"Friday" wrote:

What took you so long Jacob? It was almost 5 minutes before I received your
answer! (lol) Many thanks.

"Jacob Skaria" wrote:

1. Select the cell/Range (say E1:E10). Please note that the cell reference
E1 mentioned in the formula is the active cell in the selection. Active cell
will have a white background even after selection

2. From menu FormatConditional Formatting
3. For Condition1Select 'Formula Is' and enter the below formula
=C1<0
Click Format ButtonPattern and select your color (say Red)

4. Click on Add button.

5. For Condition2Select 'Formula Is' and enter the below formula
=C10
Click Format ButtonPattern and select your color (say Green)

6. Click on Add button.

7. For Condition3Select 'Formula Is' and enter the below formula
=C1="B"
Click Format ButtonPattern and select your color (say Yellow)

8. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Friday" wrote:

How can I conditionally format (highlight) some cells in column E based on
the values in column C of the same row?

I have no trouble highlighting a column based on it's values, but I need to
highlight the cells in a column based on the values in a different column but
the same row.

Example: If C1 is negative, highlight E1 in red.
If C2 is positive, highlight E2 in green.
If C6 = "B", highlight E6 in yellow, etc.

I'm having trouble having the value/formula in conditional formatting refer
to a different cell, but cannot specify a specific cell for all rows, if that
makes sense.


Thanks.