+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting formula requires updating to not be invoked if field contain blank

Hybrid View

  1. #1
    Registered User
    Join Date
    03-22-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    77

    Question Conditional formatting formula requires updating to not be invoked if field contain blank

    Hi
    I have a conditonal format set up which puts a strikethrough through a row when a formula "equals dollar F4 less than TODAY" is met.

    Problem is when I add text to a new line it starts by adding the strikethrough to the text because the date in F4 is blank (so I am guessing means its less that today)

    Is there an additional condition that can be added to the formula so it will exclude the space in the date field, thus prevent the text being struckthrough when I start typing.

    To try to explain what I am saying, in the attached sheet - In "all resourcing requests", If you add a value in cell A12, you'll see that it is being added grey with a strikethrough - this is the conditional formatting, which I need updating I think

    Thanks for your help

    Rob
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,962

    Re: Conditional formatting formula requires updating to not be invoked if field contain bl

    Have a look at the attached. Is this what you mean?

    BSB

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional formatting formula requires updating to not be invoked if field contain bl

    Hi

    =AND($F4<>"",$F4< Today())
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Registered User
    Join Date
    03-22-2013
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2010
    Posts
    77

    Re: Conditional formatting formula requires updating to not be invoked if field contain bl

    Hi Richard - You have solved it - thats brilliant - thank you so much

    Rob

  5. #5
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Conditional formatting formula requires updating to not be invoked if field contain bl

    Glad to have helped and thanks for the rep.

+ 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. Replies: 6
    Last Post: 09-20-2020, 06:58 PM
  2. Conditional Formatting using Formula field
    By xvynusx in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2013, 03:22 AM
  3. Replies: 1
    Last Post: 07-30-2012, 01:48 AM
  4. One criteria AND cell is blank in conditional formatting formula?
    By westis in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2008, 06:37 PM
  5. Updating links requires passwords
    By Rasfos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2007, 10:02 AM
  6. Help with conditional formatting:requires comments
    By changetires in forum Excel General
    Replies: 5
    Last Post: 09-01-2006, 12:26 PM
  7. [SOLVED] Can you put a formula on a field that requires user input?
    By Nan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-15-2006, 03:10 PM

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