Results 1 to 9 of 9

hiding conditional format when activating cell is empty

Threaded View

nje hiding conditional format... 07-26-2010, 12:04 PM
contaminated Re: hiding conditional format... 07-26-2010, 12:16 PM
nje Re: hiding conditional format... 07-26-2010, 01:33 PM
nje Re: hiding conditional format... 07-27-2010, 04:03 AM
martindwilson Re: hiding conditional format... 07-27-2010, 04:16 AM
nje Re: hiding conditional format... 07-27-2010, 04:54 AM
martindwilson Re: hiding conditional format... 07-27-2010, 06:23 AM
nje Re: hiding conditional format... 07-27-2010, 07:14 AM
nje Re: hiding conditional format... 07-27-2010, 04:17 PM
  1. #1
    Valued Forum Contributor
    Join Date
    06-23-2010
    Location
    North West
    MS-Off Ver
    office 2010
    Posts
    355

    hiding conditional format when activating cell is empty

    Sorry for that title but this is difficult to explain. I have uploaded a sample workbook to show it better.
    I'm refering to the small blue info box on the right of sheet 1 and also the duplicate on sheet 2.
    The left side of the box is where I will insert qualification, and the left mostly are the expiry dates. The details are then replicated in other worksheets as in sheet 2.
    I have conditionally formatted column 'X' to 'ALERT' when the date is within 60 days of the expiry date (that bit works OK)
    but
    if the master info block (sheet 1) doesn't have a date in it down the righthand side, two things happen
    1. , the subseqeunt box on the following sheet show the date 0 January 1901 with the 'Alert' flag showing alongside it.
    2. The 'Alert' warning flag shows on the master info block (sheet 1)
    I would like to hide the 'Alert' and the 1901 date if possible when there is no date in the righthand column.
    I hope you can follow this pathetic attempt at explaining the problem.
    Additinally for some unknown reason a '0' as appeared in column 'U' on sheet two if you could also advise on that.
    Thank you very much
    Attached Files Attached Files
    Last edited by nje; 07-27-2010 at 04:19 PM.

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