# Conditional fomatting based on adjacent cell value

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

2. ## Re: Conditional fomatting based on adjacent cell value

if you want them in a single color until the above criteria are fulfilled then: =OR(AND(D8="A", E8="Y"),AND(D8="B", E8="Y")) select the column and apply the CF rule.

3. ## Re: Conditional fomatting based on adjacent cell value

Hi,

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

4. ## Re: Conditional fomatting based on adjacent cell value

What I want to do is do some conditional formatting
You said conditional formatting. The above formula is for conditional formatting. The bellow is for values:
=IF(AND(D8="A", E8="Y"),100,if(AND(D8="B", E8="Y")),50,""))

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1