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
  #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

  #2  
Old August 24th, 2005, 10:41 PM
Chuck Snyder
external usenet poster
 
Posts: n/a
Default

Angela: In the case of Excel 2003, what appears in the PivotTable is
(blank), and it appears to be treated as text. The conditional IF
((a1="(blank)", T, F) appears to work well.

Now the color....that I don't know how to do.

Chuck


  #3  
Old August 24th, 2005, 11:05 PM
Chuck Snyder
external usenet poster
 
Posts: n/a
Default

You can also go back into the list from which your PivotTable was derived
and fill in all the blanks with N/A or a period or whatever character you'd
like. Steps:

1. Select an area of the spreadsheet that encompasses all the blanks.
2. Do an EditGoTo
3. Click on the Special button
4. Select the Blanks radio button and hit OK
5. Type in the replacement character.
6. Do a Ctrl-Enter to fill in all the blank cells.

Adapted from "Pivot Table Data Crunching" by Jelen and Alexander, p. 21.

Chuck


  #4  
Old August 25th, 2005, 05:31 PM
anjgoss
external usenet poster
 
Posts: n/a
Default


Chuck - that did it - THANKS!!
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 07:30 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.