Is it possible?
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Is it possible?

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi all

    I have a s/sheet which gives me the product structure (Bill of Material) for numerous parent codes.
    Column A shows Parent Code, B shows part code, C shows part description, D - part cost, E - Qty, F - Extended Cost.
    Now having downloaded and FTP'd from the MRP system I then used Data>Subtotals to split all parents and give me a total underneath ext'd cost.
    Great, but a few part codes have zero costs, so having sorted by ext'd cost the zeros sit at the bottom end of the structure.
    Now all I need to do is flag them somehow so it is apparent that the cost is incomplete.
    Is it possible to run a code or do anything else that will highlight the complete Row if the figure in column D is zero?
    Sorry if that was a little longwinded!!


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-03 05:52, MattB wrote:
    Hi all

    I have a s/sheet which gives me the product structure (Bill of Material) for numerous parent codes.
    Column A shows Parent Code, B shows part code, C shows part description, D - part cost, E - Qty, F - Extended Cost.
    Now having downloaded and FTP'd from the MRP system I then used Data>Subtotals to split all parents and give me a total underneath ext'd cost.
    Great, but a few part codes have zero costs, so having sorted by ext'd cost the zeros sit at the bottom end of the structure.
    Now all I need to do is flag them somehow so it is apparent that the cost is incomplete.
    Is it possible to run a code or do anything else that will highlight the complete Row if the figure in column D is zero?
    Sorry if that was a little longwinded!!

    You could use Conditional Formating under the Format Menu.

    if you data starts in row 1 highlight the whole area (Important! highlight top left to bottom right).

    Open the Conditional Formating and change the Cell Value Is to Formula is and put:

    =AND($D1=0,LEN($D1)>0)

    it's important to use the $ as they are.

    Click the Format button a select how you'd like it.

    any probs let me know.
    "Have a good time......all the time"
    Ian Mac

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Splendid!
    Thanks - I knew how to highlight selected cells using cond.format. but not the whole row.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com