+ Reply to Thread
Results 1 to 3 of 3

Validation Rules Fading

  1. #1
    Registered User
    Join Date
    08-29-2013
    Location
    New York
    MS-Off Ver
    Excel 2013
    Posts
    1

    Validation Rules Fading

    I am working on a spreadsheet with data validation in place for some columns. However, the yellow validation input message fades and becomes illegible after a few minutes of work on the spreadsheet (font turns from black to white). When I close it and reopen it after this happens, an error occurs and the spreadsheet fails to open until I try a second time and the spreadsheet opens with the input message restored until it fades and the problem starts again. Does anyone know what the cause of this problem might be? The validation rules were all done on about 50 columns using the list option with a series of highlighted values providing an exhaustive range of what is allowed to be entered in a given column. Do these types of problems arise when too many list validations are used? If so, does anyone have any links explaining alternate ways of customizing validation rules using a custom formula? All of these rules have to restrict columns to a range of whole numbers, but also allow for our missing data code of 99, which falls outside the range.

    Thank you for your help.

  2. #2
    Forum Contributor
    Join Date
    08-15-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2007
    Posts
    245

    Re: Validation Rules Fading

    Can you upload a sample and indicate where on the spreadsheet you're seeing the problem?
    <--- If you like the answer, press *.

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Validation Rules Fading

    Doesn't sound like a Data Validation problem sounds more like Conditional Formatting has been set somewhere.

    Fading font sounds like something out of a mystery movie with fading ink! LOL

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. validation rules not working when someone copy paste data on validation cell
    By jthakrar in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-17-2010, 03:36 AM
  2. Replies: 2
    Last Post: 01-03-2010, 05:21 PM
  3. Validation Rules
    By stoney1977 in forum Excel General
    Replies: 2
    Last Post: 09-21-2007, 01:45 AM
  4. Fading Form
    By helmekki in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2005, 01:10 AM
  5. [SOLVED] Validation rules
    By Souris in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2005, 04:05 PM

Tags for this Thread

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