+ Reply to Thread
Results 1 to 3 of 3

How to get CF formula to skip if lookup cell is blank.

  1. #1
    Registered User
    Join Date
    11-15-2013
    Location
    Newquay, Cornwall
    MS-Off Ver
    Excel 2010
    Posts
    67

    How to get CF formula to skip if lookup cell is blank.

    Hello all,

    I currently have a conditional format formula which simply compares one cell to another and colours the cell in the appropriate colour. How do I get the formula to "skip" if the lookup cell is blank?

    The formula is:

    Please Login or Register  to view this content.
    So if AF2 is blank, I want it to ignore the formula.

    So should it be something like:

    Please Login or Register  to view this content.
    ?
    Still learning... one day I will be able to help!

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,592

    Re: How to get CF formula to skip if lookup cell is blank.

    Use

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

  3. #3
    Registered User
    Join Date
    11-15-2013
    Location
    Newquay, Cornwall
    MS-Off Ver
    Excel 2010
    Posts
    67

    Re: How to get CF formula to skip if lookup cell is blank.

    Thanks. I just tried it but VBA Editor is saying the first '$' is an invalid character?

    The full line is:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Copy/Paste data based on value of another cell. SKIP BLANK ROWS.
    By mamero in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-14-2015, 04:46 PM
  2. How to skip blank cells and use formula
    By emp2013 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2014, 08:56 PM
  3. [SOLVED] Conditional formatting formula (around border) & skip blank cell
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2014, 07:02 PM
  4. Vlookup formula to skip blank cell and give the next value
    By Kehjz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-19-2013, 06:06 AM
  5. Replies: 4
    Last Post: 04-09-2012, 12:06 PM
  6. Skip Blank Cell and Go To Next Row
    By AnskyCJ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2010, 07:37 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1