Conditionally format all rows until the last row.

**themob212** · 10-19-2016, 09:25 AM

Hi all.
I was hoping for a little help as I am trying to set up conditional formatting so highlighting applied my range (H2:Ox) where x is the last row with content in column H.
Some googling led me to the following:
Defined name LastRw = MATCH(9.9E+307,$A:$A).
As such I think my range is =INDIRECT("$H$2:"&("$H"&"$"&(ROW()=LastRw)))
My issue is I have no idea how I would go around setting this up so that every row is highlighted, not just the last one. If it helps the formula for highlighting the last row is =ROW()=LastRw and that certainly works.
Any help you could give me would be great
Thanks
Ben

**TMS** · 10-19-2016, 10:01 AM

Maybe:

Formula:

Please Login or Register  to view this content.

**themob212** · 10-19-2016, 10:21 AM

You are fantastic and I am embarrassed.
Could you quickly explain how that works? Its been a long day and I cannot wrap my head around it.

**TMS** · 10-19-2016, 10:54 AM

You're welcome.

It is just saying current row (ROW()) is less than or equal to the last row (LastRw).

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

Conditionally format all rows until the last row.

LinkBack

Thread Tools

Rate This Thread

Display

Conditionally format all rows until the last row.

Re: Conditionally format all rows until the last row.

Re: Conditionally format all rows until the last row.

Re: Conditionally format all rows until the last row.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] conditionally format alternate rows every time the unique label changes In column B

Conditionally format a cell based on multiple criteria including format cell

[SOLVED] Excel - combine rows with previous rows - conditionally

Best Way to Conditionally Format Range (Multiple Columns and Rows)?

Format Conditionally with VBA

Merging rows of data and insertin rows conditionally

Trying to conditionally format

Bookmarks

Bookmarks

Posting Permissions