+ Reply to Thread
Results 1 to 4 of 4

Conditional fomatting based on adjacent cell value

  1. #1
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    111

    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
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    1,909

    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.
    Click the * to say thanks.

  3. #3
    Forum Contributor
    Join Date
    03-24-2010
    Location
    North West UK
    MS-Off Ver
    2013
    Posts
    111

    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. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    1,909

    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,""))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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