+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : unable to leave cells blank if reference cell is blank

  1. #1
    Registered User
    Join Date
    07-13-2008
    Location
    Tacoma
    Posts
    8

    unable to leave cells blank if reference cell is blank

    I’m having trouble with conditional formatting. If I leave column A empty I want column D to not auto fill. Right now it fills yellow based off the last rule I created in conditional formatting. I can’t seem to find the right formula to leave it blank. Thanks in advance for the help.

    aztec
    Attached Files Attached Files

  2. #2
    Forum Contributor ptm0412's Avatar
    Join Date
    04-16-2008
    Location
    Vietnam
    MS-Off Ver
    Office 2003 and 2007
    Posts
    129
    You may change the condition =A3=0 to =A3="" then move it up to top.

  3. #3
    Registered User
    Join Date
    07-13-2008
    Location
    Tacoma
    Posts
    8
    hmm...that seems to work up to row 8 then even though rows 8 & 9 have data in them they now show blank.

  4. #4
    Forum Contributor ptm0412's Avatar
    Join Date
    04-16-2008
    Location
    Vietnam
    MS-Off Ver
    Office 2003 and 2007
    Posts
    129
    Look the file.
    Perhaps You change =A3="" but Apply for D1:D238 instead of D3:D238
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-13-2008
    Location
    Tacoma
    Posts
    8
    you're a genius. I can't believe I didn't catch that. Thanks for the help.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1