Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Highlighting a row (Excel 2003)

    I want to know how I can set it up so that a row in excel highlights after I have entered all the information needed

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighting a row (Excel 2003)

    Hi Nancy,

    Could you tell us how exactly to decide when all the information needed has been entered?

  3. #3
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting a row (Excel 2003)

    I would want it to highlight after the sixth column of the row of information is entered.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighting a row (Excel 2003)

    Sorry to keep on nagging, but we need to have specific information - which cells exactly? I'm afraid that I don't understand what you mean by "I would want it (i.e. the row) to highlight after the six row (???) of information is entered."

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighting a row (Excel 2003)

    OK, I see you edited your post. Should the row be highlighted if there is something in column F (columns A through E can be filled or not), or if there is something in each of the columns A through F?

  6. #6
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting a row (Excel 2003)

    The spreadsheet I have list names, titles, hire date, evaluation scores, next eval date and salaries. As the evals are sent to me all, I have to enter is their score, next eval date and double check salaries. After I have entered the information I would like it to highlight to let me know that it is complete.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighting a row (Excel 2003)

    Select the entire sheet.
    Select Format | Conditional Formatting...
    Select Formula Is from the first dropdown.
    Enter the formula

    =COUNTBLANK($A1:$F1)=0

    in the box next to it.
    Click Format...
    Specify a highlight color in the Pattern tab.
    Click OK (twice)
    If you wish, you can now select row 1 and delete the conditional formatting.

    See the attached sample workbook.

  8. #8
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting a row (Excel 2003)

    Hans, on the attached worksheet you sent, after the infomation is filled in, is it suppose to highlight the row?

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighting a row (Excel 2003)

    The screenshot below shows how it works for me. In row 2 and row 5, all data in columns A through F have been filled in. These rows are highlighted. In rows 3 and 4 (and all rows below row 5), some data are lacking, so these rows are not highlighted. Does it work differently for you? Or did you want something else?

  10. #10
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting a row (Excel 2003)

    Its exactly what I wanted! The color was so light I could not see it. I see it now. I will try it at work tomorrow.

  11. #11
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Highlighting a row (Excel 2003)

    You can change the highlight color to whatever you prefer.

  12. #12
    New Lounger
    Join Date
    Jun 2005
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Highlighting a row (Excel 2003)

    Thank you very much!!!

Posting Permissions

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