+ Reply to Thread
Results 1 to 4 of 4

Formatting cell colour, depending on the colour of another cell

  1. #1
    Registered User
    Join Date
    09-27-2018
    Location
    Minehead. England
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    2

    Formatting cell colour, depending on the colour of another cell

    I would like to conditionally format multiple cells to be a particular colour, depending on the colour of another cell which will be changed manually and without a formula.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,018

    Re: Formatting cell colour, depending on the colour of another cell

    Basically, It requires VBA code and is by no means an easy task, as change of color of the fill or the text do not start event "Change" as changing value do.

    So first advice is to rething and may be change concept to use standard conditional formatting (as it relates to other cells - with a rule based on formula).

    Second is - prepare representative sample and attach workbook here. (10-20 rows of data is usually enough) Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

    3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

    To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    09-27-2018
    Location
    Minehead. England
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    2

    Re: Formatting cell colour, depending on the colour of another cell

    I think I have attached a very simple example of the sort of thing I would like to do. Thanks!
    Attached Files Attached Files

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,018

    Re: Formatting cell colour, depending on the colour of another cell

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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. Excel 2010 Display a certain colour in a cell depending on a value on another cell
    By JohnHamilton in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 05-08-2017, 06:26 AM
  2. Formula to change colour AND text in cell depending on value in adjacent cell
    By helsbels44 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-01-2017, 11:03 AM
  3. Replies: 6
    Last Post: 04-11-2016, 09:48 AM
  4. Select and colour cell depending on rank of number (macro conditional formatting)
    By mrpwebb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2014, 03:59 PM
  5. Replies: 1
    Last Post: 09-12-2013, 02:09 PM
  6. VBA Colour Row depending on the value of a cell
    By ottax0 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2011, 06:37 AM
  7. Replies: 2
    Last Post: 01-06-2006, 03:50 AM

Tags for this Thread

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