Thread: excel spreadsheets / blank cells

  1. #1
    essence of digital xddxogm3's Avatar
    Join Date
    Sep 2003
    Posts
    589

    excel spreadsheets / blank cells

    I'm trying to find blank cells and issue a warning message.

    I have tried the following.

    (1) Conditional Formating
    Worked, but this only highlights the cell in red no warning.

    (2) Cell formula IF(ISBLANK(CELL), "error",)
    gives me a circular reference error.

    Does anyone know a way to do this?
    It seems like an easy task, but it has escaped me.
    "Hence to fight and conquer in all your battles is not supreme excellence;
    supreme excellence consists in breaking the enemy's resistance without fighting."
    Art of War Sun Tzu

  2. #2
    Handy Andy andyhunter's Avatar
    Join Date
    Dec 2004
    Posts
    540
    Are you doing this using VBA or I guess just straight excel formula logic, huh?
    i don't think most standard compilers support programmers with more than 4 red boxes - Misplaced

    It is my sacred duity to stand in the path of the flood of ignorance and blatant stupidity... - quzah

    Such pointless tricks ceased to be interesting or useful when we came down from the trees and started using higher level languages. - Salem

  3. #3
    essence of digital xddxogm3's Avatar
    Join Date
    Sep 2003
    Posts
    589
    all excel formula logic.
    i have tried the following combinations.
    Code:
    =IF(ISBLANK(A5),"error",A5) //circular reference
    =IF(A5="","error",A5)// circular reference
    Last edited by xviddivxoggmp3; 06-12-2005 at 03:58 AM.
    "Hence to fight and conquer in all your battles is not supreme excellence;
    supreme excellence consists in breaking the enemy's resistance without fighting."
    Art of War Sun Tzu

  4. #4
    PC Fixer-Upper Waldo2k2's Avatar
    Join Date
    May 2002
    Posts
    2,001
    is it possible to only run those checks when the file is saved??
    PHP and XML
    Let's talk about SAX

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Reading Excel Row Cells A through J
    By CheyenneWay in forum C++ Programming
    Replies: 37
    Last Post: 03-17-2011, 08:00 AM
  2. Dissecting an Excel XML spreadsheet
    By desmond5 in forum C++ Programming
    Replies: 1
    Last Post: 05-22-2008, 04:32 PM
  3. Write/Read Excel Cells
    By rogster001 in forum C Programming
    Replies: 15
    Last Post: 02-26-2008, 04:54 AM
  4. Excel Spreadsheets
    By LiteIce in forum C# Programming
    Replies: 0
    Last Post: 11-08-2007, 01:24 AM
  5. Merging the cells of excel from vc++
    By yongzai in forum Windows Programming
    Replies: 1
    Last Post: 06-16-2006, 03:42 AM