+ Reply to Thread
Results 1 to 6 of 6

Conditional formatting involving numbers and text

  1. #1
    Registered User
    Join Date
    04-24-2019
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    95

    Conditional formatting involving numbers and text

    Hi there

    I hope you can help with query below / attached file.

    Using ‘Conditional Formatting’ on column ‘F’ (Time in Service) how can I highlight cells that are greater than or equal to ‘3 months’?

    Thanks
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Conditional formatting involving numbers and text

    Please try CF formula
    =DATEDIF($E2,TODAY(),"m")*($D2="open")>=3

    applies to F2:F11

  3. #3
    Registered User
    Join Date
    04-24-2019
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    95

    Re: Conditional formatting involving numbers and text

    Excellent! thank you Bo_Ry.

  4. #4
    Registered User
    Join Date
    04-24-2019
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    95

    Re: Conditional formatting involving numbers and text

    Hi Bo

    Any chance i can modify the above formula not to highlight blank cells i.e. if col F 'Date started with service' is blank?

    Thanks

  5. #5
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Conditional formatting involving numbers and text

    Yes,

    =(DATEDIF($E2,TODAY(),"m")*($D2="open")>=3)*($F2<>"")

  6. #6
    Registered User
    Join Date
    04-24-2019
    Location
    Manchester
    MS-Off Ver
    2010
    Posts
    95

    Re: Conditional formatting involving numbers and text

    Great stuff! Thank you Bo_Ry.

+ 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. [SOLVED] Calculations involving text and numbers
    By kierand99 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-17-2018, 04:50 PM
  2. Replies: 5
    Last Post: 11-05-2015, 04:19 PM
  3. [SOLVED] triple conditional formatting, involving dates and blanks, can't figure out the problem
    By Severine72 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-13-2015, 01:57 AM
  4. Question Involving Conditional Formatting:
    By DeltaHoot82nd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-28-2012, 11:30 PM
  5. Replies: 4
    Last Post: 06-28-2012, 01:07 PM
  6. Replies: 9
    Last Post: 03-26-2012, 02:16 PM
  7. If statement involving numbers and text
    By Wholffie in forum Excel General
    Replies: 1
    Last Post: 01-28-2009, 03:29 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