+ Reply to Thread
Results 1 to 5 of 5

Copying Conditional Formatting to the adjacent Cell

  1. #1
    Registered User
    Join Date
    10-14-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Copying Conditional Formatting to the adjacent Cell

    Hi,

    I've had a look around for a solution to this, but none of the other answers seem to quite do what I'd like to.

    I currently have a drop down box in A1 that has CF on it. The drop down options are Yes and No. If it's a Yes the cell goes green. If it's a not it goes red.

    A2 will be used for Notes to be typed explaining why A1 is a Yes or a No but what I'd like is for A2 to turn the same colour as A1 when a drop down is selected, yet still have space for the User to type notes in A2.

    I can't see an option for this in the CF options so the only other way I can think of doing it would be to add another column and put a formula in there which relates to the formatting of A2. I'm just not sure of formulas that relate to formatting!

    Any help much appreciated! :-)

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,137

    Re: Copying Conditional Formatting to the adjacent Cell

    Select cell A2 then click on Conditional Formatting | New Rule | Use a Formula... , then put this formula in the dialogue box:

    =A1="Yes"

    Click the Format button | Fill tab and choose green, then OK your way out.

    Repeat this, but use the formula:

    =A1="No"

    and set that colour to red.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-14-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Copying Conditional Formatting to the adjacent Cell

    Wow. That really was a lot more simple than I thought it'd be!

    Thank you, Pete

  4. #4
    Registered User
    Join Date
    10-14-2009
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Copying Conditional Formatting to the adjacent Cell

    Wow. That really was a lot more simple than I thought it'd be!

    Thank you, Pete

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    23,137

    Re: Copying Conditional Formatting to the adjacent Cell

    Glad to help, Oliver.

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] conditional formatting adjacent cell
    By warston in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2015, 07:31 AM
  2. [SOLVED] Conditional formatting in adjacent cell
    By kenjmaraty in forum Excel General
    Replies: 2
    Last Post: 04-25-2015, 11:55 AM
  3. Conditional formatting adjacent cell
    By dkbell@gmail.com in forum Excel General
    Replies: 1
    Last Post: 04-07-2015, 12:46 PM
  4. [SOLVED] adjacent cell conditional formatting
    By IronCladRooster in forum Excel General
    Replies: 3
    Last Post: 08-07-2014, 10:08 AM
  5. Conditional formatting on adjacent cell
    By branred in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2013, 03:40 AM
  6. Copying Conditional Formatting to Adjacent Cells
    By arsenal123gunners in forum Excel General
    Replies: 1
    Last Post: 06-24-2010, 09:24 PM
  7. Replies: 2
    Last Post: 01-10-2005, 06:06 PM

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