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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 18th, 2005 11:37 PM |