Results 1 to 9 of 9

hiding conditional format when activating cell is empty

Threaded View

  1. #3
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    Re: hiding conditional format when activating cell is empty

    Thanks HTH, In answer to your question, yes that's what I'm looking for, but I couldn't get it to work on my copy so I looked at how you did it and have cocked it up a bit (sheet 2 H11) I'm not sure what I've done but it won't work. I tried entering your formula into the conditional format and pulling it down from the others above, but failed, There are quite a few other headings and dates to go in the box so I would like to be able to understand what I've done wrong.
    I don't know how you got rid of the '0' in column 'U' but thanks again for that.

    My problems are still on sheet one with the 'Alert' flag still showing if there is no date in it, but what you have achieved in such a short time on sheet two is great I have upload the two sheets you have worked on to show you how I cocked it up(sorry) I have attached the cocked up version
    Attached Files Attached Files
    Last edited by nje; 07-26-2010 at 01:37 PM. Reason: forgot attachment

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