+ Reply to Thread
Results 1 to 5 of 5

Bold Cell

  1. #1
    Registered User
    Join Date
    03-23-2010
    Location
    Melbourne Australia Down Under
    MS-Off Ver
    Excel 2010
    Posts
    56

    Question Bold Cell

    Hi
    I am currently using this code in excel to perform a function of evaluation two dates to determine which one is “Out of Order”

    Please Login or Register  to view this content.
    What the code will not currently do is bold the cell that contains Out of Order

    Any ideas where I am going wrong

    Many thanks
    Have a great day!!!!

    Lou

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Bold Cell

    You're comparing the same two dates repeatedly.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    03-23-2010
    Location
    Melbourne Australia Down Under
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Bold Cell

    Yes, as it is evaluating a column of dates

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Bold Cell

    If that's meant to be a UDF (a function called from the worksheet), it won't work -- UDFs, with odd exceptions, can't do anything but return a value to the cell in which they appear.

  5. #5
    Registered User
    Join Date
    03-23-2010
    Location
    Melbourne Australia Down Under
    MS-Off Ver
    Excel 2010
    Posts
    56

    Re: Bold Cell

    Thanks for that advice. I was not aware.

    Once again many thanks

+ 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