+ Reply to Thread
Results 1 to 8 of 8

looping to find empty cells and color the offset (0, 1) cell.

  1. 01-05-2015, 04:33 PM #1
    Neil35
    Neil35 is offline
    Registered User
    Join Date
    01-05-2015
    Location
    Washington DC
    MS-Off Ver
    2010
    Posts
    4

    looping to find empty cells and color the offset (0, 1) cell.

    Hello, Ive been trying to loop through my sheet of loans and identify the loans that do not have loan numbers. If there is not a loan number in the active cell and the activecell.offset (0, 1) is one of my 6 different banks, then i want to color the the cell red. if there is a loan number in the active cell, i want it to go to go on with the search. ive tried several different techniques and the VB is not regognizing the empty cell. below is one that i have tried.


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 01-05-2015, 04:37 PM #2
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: looping to find empty cells and color the offset (0, 1) cell.

    Hi, and welcome to the forum.

    You'll need to upload the workbook and clearly explain by reference to specific cells what you expect to happen and why. You may not need a macro if there is a conditional formatting solution.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 01-05-2015, 04:47 PM #3
    Neil35
    Neil35 is offline
    Registered User
    Join Date
    01-05-2015
    Location
    Washington DC
    MS-Off Ver
    2010
    Posts
    4

    Re: looping to find empty cells and color the offset (0, 1) cell.

    Lock Check For Errors USBank EZD.xlsm

    I want to search column C and if its blank I want to check column D for the bank, and if its a certain bank, then color the cell red. Not all the banks will require a loan number in column C. Thanks for your help.
    Reply With QuoteRegister To Reply
  4. 01-05-2015, 04:53 PM #4
    Mumps1
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,028

    Re: looping to find empty cells and color the offset (0, 1) cell.

    Which banks would be colored red? Which banks require a loan number?
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.
    Reply With QuoteRegister To Reply
  5. 01-05-2015, 05:14 PM #5
    Neil35
    Neil35 is offline
    Registered User
    Join Date
    01-05-2015
    Location
    Washington DC
    MS-Off Ver
    2010
    Posts
    4

    Re: looping to find empty cells and color the offset (0, 1) cell.

    there are 20 banks that require loan numbers and 7 that do not require a loan number.

    i will give you a few to test unless you will need all of them.

    Do need a loan number in [C]

    Chase
    US Bank
    SunTrust
    Wells Fargo
    VHDA
    BB&T
    Reply With QuoteRegister To Reply
  6. 01-05-2015, 05:15 PM #6
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: looping to find empty cells and color the offset (0, 1) cell.

    Hi,

    Maybe a conditional format entered in C2

    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    and applied to the whole of column C.
    Reply With QuoteRegister To Reply
  7. 01-06-2015, 03:09 AM #7
    apo
    apo is offline
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looping to find empty cells and color the offset (0, 1) cell.

    Hi..

    Try this..

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 01-07-2015, 02:53 PM #8
    Neil35
    Neil35 is offline
    Registered User
    Join Date
    01-05-2015
    Location
    Washington DC
    MS-Off Ver
    2010
    Posts
    4

    Re: looping to find empty cells and color the offset (0, 1) cell.

    Thanks for the help guys, I was able to use the conditional formatting formula provided. It seems to be working. This will save me a bunch of time!.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Find empty cell in column, and apply required character to empty visable cells.
    By Chris Acheson in forum Excel General
    Replies: 5
    Last Post: 05-13-2014, 10:19 AM
  2. Need to find empty filled cells in a column and copy to the empty cell below
    By Grahamfeeley in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-30-2014, 10:09 AM
  3. [SOLVED] find cells with values that fall between dynamic start and end value, color offset (-1,0)
    By ThaGonz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2014, 11:56 PM
  4. [SOLVED] Find first non-blank cell after a group of blanks copy offset cells, find next blank, loop
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-21-2012, 06:11 AM
  5. Find out if a range of cells match a criteria cell, if yes, color Green, if no color Red
    By r71lima in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 09-18-2012, 03:13 PM

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1