A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"BLANK" - need to delete



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old August 24th, 2005, 10:01 PM
anjgoss
external usenet poster
 
Posts: n/a
Default "BLANK" - need to delete


when using a pivot - the word "BLANK" transfers in when the data sheet
has a blank area...

How can I get that to be just blank so that I can use that cell in a
conditional formatting scenario?

I want to say...
=IF(Q8="blank")

if Q8 is blank, then turn red
if Q8 has a value, then turn green

Angela


--
anjgoss
------------------------------------------------------------------------
anjgoss's Profile: http://www.excelforum.com/member.php...o&userid=26602
View this thread: http://www.excelforum.com/showthread...hreadid=398765

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I delete blank second pages in Access reports? anelson General Discussion 1 September 13th, 2005 05:45 PM
How can I DELETE a CONTACT from the Contacts Folder without an Err Frustrated & Fuming in Fairview Contacts 1 July 5th, 2005 08:52 PM
How do I delete extra blank pages at end of doc...only show when. LV General Discussion 4 April 20th, 2005 05:13 PM
blank data field shows quote in formula, how to delete it? wdanner General Discussion 2 April 4th, 2005 08:44 PM
delete entries with a specific field that is blank in Outlook 2000 [email protected] Contacts 0 March 19th, 2005 12:37 AM


All times are GMT +1. The time now is 04:23 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.