+ Reply to Thread
Results 1 to 4 of 4

Use format of one cell to change type of format used in conditional format

  1. #1
    Registered User
    Join Date
    03-29-2009
    Location
    Oregon, USA
    MS-Off Ver
    Excel 2016
    Posts
    47

    Use format of one cell to change type of format used in conditional format

    I don't know if it matters but I am working on an .xls document in compatibility mode using MS excel 2010.

    Using this forum I was able to write conditional formatting formulas that would automatically change the color of entire rows anywhere on the spreadsheet whenever 1 of 6 different names were entered in one column and the next column contained either "PU" or "DO". This was a great feat for me as I am by no means an expert and do not know VBA. However cool this was, I would still need to rewrite the conditional formatting for the entire sheet when new names occur in the future.

    I would like to select which format type used in conditional formatting remotely - e.g. by formatting a cell (say T1) in Green I could then have the conditional format refer to that cell to select green text formatting to use on the proscribed condition.

    -__T__U
    1__1__Matthew
    2__2__Landon

    A related, and likely simpler request is to also have conditions referenced remotely - e.g. a list of names that would trigger the conditional formatting.

    Ideally the name could be formatted as desired to show in conditional formatting, then I could skip colored numbers & just have list of names.

    In this way, as the possible names change over time I would not need to rewrite the formulas to conditionally format the worksheet, I could write the formulas once and then just enter names in a list using formatting I desire and the conditional format formulas would do the rest!
    Attached Files Attached Files

  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,561

    Re: Use format of one cell to change type of format used in conditional format

    I would like to select which format type used in conditional formatting remotely - e.g. by formatting a cell (say T1) in Green I could then have the conditional format refer to that cell to select green text formatting to use on the proscribed condition.
    To the best of my knowledge, this is not possible with regular CF. CF works on rules you provide inside the CF window
    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
    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,561

    Re: Use format of one cell to change type of format used in conditional format

    I would like to select which format type used in conditional formatting remotely - e.g. by formatting a cell (say T1) in Green I could then have the conditional format refer to that cell to select green text formatting to use on the proscribed condition.
    To the best of my knowledge, this is not possible with regular CF. CF works on rules you provide inside the CF window

  4. #4
    Registered User
    Join Date
    03-29-2009
    Location
    Oregon, USA
    MS-Off Ver
    Excel 2016
    Posts
    47

    Re: Use format of one cell to change type of format used in conditional format

    Thanks FDibbins, even though it's not the answer I hoped for, at least I can stop looking now...from what I've seen so far, if it could be done you would have known something about it.

    On the other hand, if I give up on the "remote text formatting" idea I think it's possible to have all of the desired text colors as separate rules within the CF window - each color rule having a formula referring to a cell in a list of names. Does that make sense?

    I would still need to make a rule for each text format color or style, but that would have way fewer possibilities than all the unknown future names I might otherwise need to write a rule for.

    It seems like I ran across something on this forum that used a variable external list of "triggers" for conditional formatting, but I was searching for something else at the time and now after hours of searching I can't find that post again.

    Should I start a new post for this question?

+ 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. Conditional Format for cell Change
    By sswcharlie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2013, 05:14 PM
  2. Replies: 3
    Last Post: 05-15-2013, 12:16 AM
  3. Change format of lots of data cell to a time format
    By dazza67 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-24-2013, 03:24 PM
  4. Conditional format, change a different cell?
    By Spoolx in forum Excel General
    Replies: 3
    Last Post: 01-24-2011, 12:15 PM
  5. Lock Cell Format - Allow copy and paste of data without format change
    By Chris12InKC in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2006, 12: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