+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting multiple rows if condition is TRUE for that row

  1. #1
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    Conditional Formatting multiple rows if condition is TRUE for that row

    I would like to use conditional formatting to highlight a specific row in RED from $A$7:$AY$138
    Based on the condition, which is already established: For all the row numbers that have TRUE within =ROWS()=$AZ$7:$AZ$138
    but this condition doesn't work, I don't know how to write it!

    So what I have in column AZ looks like this:
    ROW / AZ
    7 / FALSE
    8 / FALSE
    9 / TRUE
    10 / FALSE
    11 / FALSE
    12 / FALSE
    13 / TRUE
    ....and so on until row
    138


    In the example above, rows 9 and 13 displayed TRUE, and I want those rows to be in RED (within columns A:AY).

    Please help! Thanks!

    -Nenad
    Last edited by nenadmail; 12-11-2012 at 06:16 AM.

  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: Conditional Formatting multiple rows if condition is TRUE for that row

    In Conditional Formatting rules, put this.

    =$AZ=true

    Range: =$A$7:$AY$138
    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
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643
    Select $A$7:$AY$138.

    Goto conditional formatting and enter this formula,

    =$AZ7

    and format as required.
    If posting code please use code tags, see here.

  4. #4
    Forum Contributor
    Join Date
    05-19-2012
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    200

    Re: Conditional Formatting multiple rows if condition is TRUE for that row

    Thanks Norie.... yours worked!

+ 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