+ Reply to Thread
Results 1 to 4 of 4

Apply Conditional Format to a range of cells based on other Cells

  1. #1
    Registered User
    Join Date
    07-22-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    29

    Apply Conditional Format to a range of cells based on other Cells

    I want to conditionally format (put a red border around the cell) cells in the range D10:D100, if the corresponding value in another column (say T10:T100) equals a reference value in cell S1.

    So for example: D10 gets formatted if T10 = the value in S1; D11 gets formatted if T11 = the value in S1, etc.

    Now, I can do this to format a single cell, but how to I extend this to the full range (D10:D100), given that I don't want to mess up the (fixed) formatting already present throughout column D? Eg. If I setup the conditional format on cell D10, and then do a copy and 'paste special' of 'formats' over D11 to D100 - I destroy the existing formats on D11 to D100. Similarly, if I do a right click on D10 and drag "formatting only", I destroy the existing formats on D11 to D100. So I need either:
    - A way to specify the formula in the conditional formatting such that it applies over D10:D100, OR
    - A way to extend the conditional formatting from D10 to the rest of the range in a way that is "additive" - ie. does not interfere with the preexisting formatting in the range.

    Many Thanks

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Apply Conditional Format to a range of cells based on other Cells

    Hi

    Take a look to the eXample. Put in range T10:T100, the same value as S1 and see range D10:D100.
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Registered User
    Join Date
    07-22-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Office 365
    Posts
    29

    Re: Apply Conditional Format to a range of cells based on other Cells

    That does the trick! Thanks.

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Apply Conditional Format to a range of cells based on other Cells

    You are welcome!

    Thanks for the reb*

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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