LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
KKD KKD is offline
external usenet poster
 
Posts: 31
Default Conditionally format last row of matching criteria

I want to create an underline border for a row containing a particular value.

Example:
(Headers) PO# Inv# Amt Status
(Data) ABC 123 $50.12 Multiple
ABC 456 $47.00 Multiple
AXX 789 $21.00

In this example, I want an underline to appear under the last data row that
contains a repeated PO#. So an underline would appear under the middle row,
because that is the last row of the "ABC" PO#. However, I do NOT want
underlines to appear under rows that only have a single PO#.

The status column is set up to read "multiple" if there are multiple rows
using that PO# and the status is blank if it is a single occurrence. The rows
are usually sorted by PO#.




--
KKD
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditionally format only when both criteria are met Montana Excel Discussion (Misc queries) 1 June 17th 08 11:25 PM
conditionally format anumber format Montana Excel Worksheet Functions 5 January 15th 08 05:25 PM
How do I conditionally format a chart? Midavalo Charts and Charting in Excel 1 February 21st 06 10:10 AM
conditionally format cells elad Excel Worksheet Functions 2 May 13th 05 03:57 PM
How do I conditionally format a chart? Michelle Excel Discussion (Misc queries) 1 April 12th 05 09:59 PM


All times are GMT +1. The time now is 11:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"