+ Reply to Thread
Results 1 to 4 of 4

How to condition a blank cell to N/A?

  1. #1
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to condition a blank cell to N/A?

    Hello!

    I am trying to make a condition rule that changes all of the blank cells in the document to say "N/A"...help please!

    Thanks!
    Mary
    Last edited by maryinwv; 05-15-2014 at 11:10 AM.

  2. #2
    Forum Contributor
    Join Date
    08-20-2012
    Location
    Walsall,England
    MS-Off Ver
    Excel 2007
    Posts
    125

    Re: How to condition a blank cell to N/A?

    If you want to convert blanks to N/A just use find and replace

  3. #3
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: How to condition a blank cell to N/A?

    I dont' think you can do that with conditional formatting. Here's an option
    Select your range i.e A1:M150
    F5 (GoTo)> Special
    Select "Blanks"
    then in formula bar,
    if you just want it to say N/A type that in and hit cntrl +enter
    if you want the #N/A error type in =NA() and hit contrl Enter
    Will that work for you?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  4. #4
    Registered User
    Join Date
    05-15-2014
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How to condition a blank cell to N/A?

    Thanks, @ChemistB. Works perfectly.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Toggle fill Color in cell based on condition of cell--blank or text added.
    By moosetales in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-15-2014, 08:39 PM
  2. How to sumif with condition = blank cell?
    By Poey in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2013, 03:24 AM
  3. [SOLVED] Need to know if a cell is blank if a certain condition is met.
    By Jowel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-05-2013, 03:43 AM
  4. Excel 2007 : IF condition for a blank cell
    By kenwatch in forum Excel General
    Replies: 3
    Last Post: 04-10-2010, 10:25 AM
  5. if condition for blank cell values
    By Burke in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-05-2008, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1