Results 1 to 4 of 4

Conditional Formatting multiple rows if condition is TRUE for that row

Threaded View

  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.

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