+ Reply to Thread
Results 1 to 3 of 3

Conditionally formatting a blank cell to red .

  1. 05-10-2010, 02:38 PM #1
    Excelinfant_2010
    Excelinfant_2010 is offline
    Registered User
    Join Date
    05-10-2010
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2003
    Posts
    12

    Conditionally formatting a blank cell to red .

    Hi All,

    I am trying to create a formula in conditional formatting so that when the cell is blank, it is filled red. I've done this before, but can't for the life of me figure out how to do it again. Need it for a presentation asap...

    Many thanks!!
    Last edited by Excelinfant_2010; 05-10-2010 at 02:45 PM.
    Reply With QuoteRegister To Reply
  2. 05-10-2010, 02:43 PM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,604

    Re: Conditionally formatting a blank cell to red .

    Use this:

    =ISBLANK(A1)

    Choose formating at will
    Reply With QuoteRegister To Reply
  3. 05-10-2010, 02:45 PM #3
    Excelinfant_2010
    Excelinfant_2010 is offline
    Registered User
    Join Date
    05-10-2010
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Conditionally formatting a blank cell to red .

    Amazing...many many thanks!

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1