Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditionally format only when both criteria are met | Excel Discussion (Misc queries) | |||
conditionally format anumber format | Excel Worksheet Functions | |||
How do I conditionally format a chart? | Charts and Charting in Excel | |||
conditionally format cells | Excel Worksheet Functions | |||
How do I conditionally format a chart? | Excel Discussion (Misc queries) |