Conditional fomatting based on adjacent cell value

Hi everyone,

Can't seem to work this one out.

I've a 3 columns:

D8:D250
E8:E250
F8:F250

What I want to do is do some conditional formatting where each cell in the column F will change depending on the adjacent cell values in columns D&E.

For example:

If the adjacent cell in say D = "A" and the adjacent cell in E = "Y" then the value in the cell in E needs to be 100
If the adjacent cell in D = "B" and the adjacent cell in E = "Y" then the vale of the cell in E needs to be 50

Than I want to apply that to every cell in column F

Any ideas?

Thanks

Hi,

I don't want a colour I want it to return a value if the above is true

I was hoping to find an answer here regarding multiple color formatting based on the value of an adjacent cell.
I have a column with an IF statement (I2:I22) which returns values 1,4,7 or 2,5 or 3,6,8 and based on the return value I want to color the cell in the adjacent column (H) green, yellow, or red respectively.
I wrote an OR statement in the CF and it works for that cell (H2), but if I try to drag down (H3:H22) it only looks back to the original cell(I2).
I've tried copy and paste, format painter, and paste special without any luck.
Any suggestions?

Are these 2 different posts? You went from wanting conditional formatting, to not wanting conditional formatting (or a color), to wanting a color and now in different columns. Your uploaded file has nothing in columns I or H. You reference a CF you wrote, but there is no CF in the file you updated.

When you create the CF, have the column of cells selected so it applies it to all cells.

In the formula bar of the CF, try this:
=OR(I2=3,I2=6,I2=8)

and format Red.

Continue with the other CFs.

I think this is what you want. Let us know.

My apologies for the confusion. I assumed since the answer I was looking for was the title of the thread it would be ok to post here. I will start a new thread in the future. Thanks.