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 |
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 19th, 2005 12:37 AM |