Results 1 to 3 of 3

Thread: Need help. If Column cells are blank highlight entire row.

Threaded View

  1. Nov 21st, 2011, 12:45 PM #1
    simpleonline1234
    simpleonline1234 is offline

    Thread Starter
    Hyperactive Member simpleonline1234's Avatar
    Join Date
    Mar 2010
    Posts
    322

    Need help. If Column cells are blank highlight entire row.

    Hey guys I have a mind nubbing project going on. I'm trying to create this macro for work.

    What I am trying to do is create a macro that will look at an entire column....say for instance....Column D.

    If Column D contains a blank cell then I need to highlight the entire row that cell is on ....

    It's a comparison chart....Column C has an account status and on Column D I have a macro that will run a comparison again that column and return the results in cell D for each result.

    What I need help on is how to highlight the rows where cell D is blank.

    Any ideas on how to work this into a macro?

    Thanks


    Last edited by simpleonline1234; Nov 21st, 2011 at 01:01 PM.
    Are you down with OOP?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width