excel spreadsheets / blank cells

xddxogm3 · 06-11-2005, 09:54 PM

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.

andyhunter · 06-11-2005, 11:04 PM

Are you doing this using VBA or I guess just straight excel formula logic, huh?

xddxogm3 · 06-12-2005, 03:50 AM

all excel formula logic.
i have tried the following combinations.

Code:

=IF(ISBLANK(A5),"error",A5) //circular reference
=IF(A5="","error",A5)// circular reference

Waldo2k2 · 06-14-2005, 12:10 PM

is it possible to only run those checks when the file is saved??

06-11-2005, 09:54 PM	#1
xddxogm3 essence of digital Join Date: Sep 2003 Posts: 577	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
xddxogm3 is offline

06-11-2005, 11:04 PM	#2
andyhunter Handy Andy 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
andyhunter is offline

06-12-2005, 03:50 AM	#3
xddxogm3 essence of digital Join Date: Sep 2003 Posts: 577	all excel formula logic. i have tried the following combinations. Code: =IF(ISBLANK(A5),"error",A5) //circular reference =IF(A5="","error",A5)// circular reference __________________ "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 Last edited by xviddivxoggmp3; 06-12-2005 at 03:58 AM.
xddxogm3 is offline

06-14-2005, 12:10 PM	#4
Waldo2k2 PC Fixer-Upper 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
Waldo2k2 is offline

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dissecting an Excel XML spreadsheet	desmond5	C++ Programming	1	05-22-2008 04:32 PM
Write/Read Excel Cells	rogster001	C Programming	15	02-26-2008 04:54 AM
Excel Spreadsheets	LiteIce	C# Programming	0	11-08-2007 01:24 AM
Merging the cells of excel from vc++	yongzai	Windows Programming	1	06-16-2006 03:42 AM
Reading Excel Row Cells A through J	CheyenneWay	C++ Programming	35	05-21-2004 10:08 AM