+ Reply to Thread
Results 1 to 6 of 6

Formatting cell(s) based on another cell's conditional format?

  1. #1
    Registered User
    Join Date
    05-02-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    41

    Arrow Formatting cell(s) based on another cell's conditional format?

    Hello,

    If the colour of a number formatted cell is determined by CF based on it's numerical value (say using a 3-colour scale based on the cell), how can you have this same colour formatting dynamically apply to another cell )or cells) that is instead text formatted?

    Regards

    I-Like-Excel

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,777

    Re: Formatting cell(s) based on another cell's conditional format?

    Use the same CF rule in the other cell
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-02-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Formatting cell(s) based on another cell's conditional format?

    Quote Originally Posted by FDibbins View Post
    Use the same CF rule in the other cell
    Using the same CF rule would be basing the format of the cell on the numerical value of that cell (not of another), which can be simply done by copy/pasting the CF formatting from one cell to the other. However the cell I want to format is however text. I can't see how a CF that is determined by a numerical value can work if the cell is instead text based.

    Please explain the method you have in mind.

    In case it may be unclear what I am asking: Imagine you have a cell with a regular 2-colour scale CF for values ranging between 0 (white) to 100 (red). That cell will take on a shaded colour depending on the numerical value of that cell. Now in an adjacent cell I type the text string "Temperature". I want the cell that contains the word "Temperature' to dynamically mirror the same shaded cell CF that is being applied to the adjacent numerical cell.
    Last edited by I-Like-Excel; 04-18-2021 at 10:59 AM.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,777

    Re: Formatting cell(s) based on another cell's conditional format?

    OK so what is the relationship between the number in cell "A" and the text in cell "B"? If there is no correlation between them (I cant see how "1" would relate to "temp"), how would "B" change based on what is in "A"?

    Prove a sample WB showing what you have and what you expect.

  5. #5
    Registered User
    Join Date
    05-02-2011
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    41

    Re: Formatting cell(s) based on another cell's conditional format?

    OK. The attached file should clearly illustrate what I am trying to do.

    https://www.excelforum.com/attachmen...1&d=1619156209
    Attached Files Attached Files

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,777

    Re: Formatting cell(s) based on another cell's conditional format?

    You cannot use gradient scale with a formula. so my suggestion wont work

+ 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. Replies: 9
    Last Post: 09-12-2020, 12:10 PM
  2. Conditional Formatting Based on Adjacent Cell *Format*
    By MacroPolo in forum Excel General
    Replies: 1
    Last Post: 05-18-2016, 09:59 AM
  3. Replies: 2
    Last Post: 07-28-2013, 03:28 PM
  4. [SOLVED] Workaround to Conditional Formatting based on a Format of another cell
    By sarkman22 in forum Excel General
    Replies: 5
    Last Post: 05-10-2013, 01:24 PM
  5. Using Conditional Formatting to format range based on one cell
    By panamakevin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2012, 09:50 PM
  6. Replies: 2
    Last Post: 12-21-2011, 06:01 PM
  7. Conditional Formatting 4+ conditions, format rows based on cell
    By nockam in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-12-2006, 06:12 PM

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