+ Reply to Thread
Results 1 to 3 of 3

Want to copy cell background colour to adjacent cell background colour so they match

  1. 01-05-2016, 06:28 PM #1
    someguy4321
    someguy4321 is offline
    Registered User
    Join Date
    10-09-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    2007
    Posts
    17

    Want to copy cell background colour to adjacent cell background colour so they match

    Hi there,

    I've been looking for the relevant code but can't find it online. All I want to do is:

    Let's say I've two columns E and F. F column automatically loads the correct background cell colour so that's sorted however I want E column to have the same coloured cells as F column (like a mirror image of F column). I don't want to know all the colour numbers, conditional formatting options etc all I want is simple code to copy the background cell colour from F column to E column.

    I'm using MS Office 2007 btw.

    Many thanks
    Reply With QuoteRegister To Reply
  2. 01-05-2016, 06:35 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: Want to copy cell background colour to adjacent cell background colour so they match

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 01-05-2016, 06:36 PM #3
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Want to copy cell background colour to adjacent cell background colour so they match

    The code in this thread might be a good starting point: http://www.excelforum.com/excel-form...lls-value.html
    There's a variation here: http://www.excelforum.com/excel-form...ml#post4220031
    If they don't help, get back to us.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. cell background colour
    By craig01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2015, 01:10 PM
  2. toggling background colour of a cell
    By roninn75 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2012, 02:54 AM
  3. Extract Cell Font/Background Colour
    By icu222much in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 07-02-2010, 11:17 PM
  4. Count cell background colour
    By sats43 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-04-2010, 07:08 AM
  5. Match each cell in a columns background/text colour to that of another cell?
    By Wabby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2010, 05:41 AM
  6. Cell Background Colour?
    By arfanvilla in forum Excel General
    Replies: 2
    Last Post: 05-12-2008, 05:34 AM
  7. change a cell background colour to my own RGB colour requirements
    By Stephen Doughty in forum Excel General
    Replies: 4
    Last Post: 06-16-2006, 08:15 AM
  8. [SOLVED] establishing the background colour of a cell
    By ac512 in forum Excel General
    Replies: 4
    Last Post: 04-15-2005, 04: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1