Consulting

Results 1 to 4 of 4

Thread: Conditional Format for ISBLANK

  1. 03-28-2005, 02:31 PM #1
    Anne Troy
    Anne Troy is offline
    Site Admin
    The Princess     VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location

    Conditional Format for ISBLANK

    If the cell is blank, I want to fill it yellow.

    Must be a formula, huh?

    isblank(b2) doesn't seem to work.

    How?
    ~Anne Troy
    Reply With Quote Reply With Quote
  2. 03-28-2005, 02:36 PM #2
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master     VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    B2=""

    IsBlank should work as well, but make sure you select Formula. Also the cell must be blank and not have a formula that is just returning a "".



    Reply With Quote Reply With Quote
  3. 03-28-2005, 02:43 PM #3
    Anne Troy
    Anne Troy is offline
    Site Admin
    The Princess VBAX Guru Anne Troy's Avatar
    Joined
    May 2004
    Location
    Arlington Heights, IL
    Posts
    2,530
    Location
    Duh.

    Entering the = sign is particularly helpful.

    ~Anne Troy
    Reply With Quote Reply With Quote
  4. 03-28-2005, 02:45 PM #4
    Jacob Hilderbrand
    Jacob Hilderbrand is offline
    Site Admin
    Jedi Master     VBAX Guru Jacob Hilderbrand's Avatar
    Joined
    Jun 2004
    Location
    Roseville, CA
    Posts
    3,712
    Location
    Usually




    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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