Conditional format a column based on value in a different column

F

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

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
 
F

Friday

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top