Conditional format a column based on value in a different column

[Friday]

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.

 

[Jacob Skaria]

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 Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=C1<0
Click Format Button>Pattern and select your color (say Red)

4. Click on Add button.

5. For Condition2>Select 'Formula Is' and enter the below formula
=C1>0
Click Format Button>Pattern and select your color (say Green)

6. Click on Add button.

7. For Condition3>Select 'Formula Is' and enter the below formula
=C1="B"
Click Format Button>Pattern and select your color (say Yellow)

8. Hit OK

If this post helps click Yes

 

[Friday]

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

 

[Jacob Skaria]

Cheers..

If this post helps click Yes