Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2003
    Location
    Morgantown, Pennsylvania, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting - Blank vs non-blank (Excel 2002-2003)

    Hello,

    I am trying to make Excel understand the difference between a blank cell and a cell with a zero in it, so that I can conditionally format cells with zeros in them to be a different background color than those with nothing in them.

    I've tried conditional formatting using isblank, isnontext, isnumber, all without satisfactory results. I've tried to format the cells as text, as general, as numbers, and still can get conditional formatting to understand the difference between a blank and a zero.

    Has anyone else solved this problem?

    Thanks for any suggestions.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting - Blank vs non-blank (Excel 2002-2003)

    How about something like as the formula: (assuming A1, change as desired)

    <pre>=AND(NOT(ISBLANK(A1)),A1=0)</pre>


    Steve

Posting Permissions

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