Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'Working with Multiple Sheets' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
Working with Multiple Sheets
Authored by: Yvan KOENIG on May 30, '09 07:48:48AM

Hello

The "COLOR MISSED DAYS" scripts contains what appears to be an oddity.

A cell containing the value zero (0 or 0.00) will be colored as well as really empty cells.

The only way to get rid of that is to use an auxiliary table in which you would create the formula:
=ISBLANK(theSheet :: theTable :: theCell)

grabbing the value of this cell (true or false) will give you the true status of the pointed cell.

Yvan KOENIG (from FRANCE samedi 30 mai 2009 16:48:16)



[ Reply to This | # ]