+ Reply to Thread
Results 1 to 4 of 4

How to conditionally format cells if other cells contain specific text

  1. #1
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,759

    How to conditionally format cells if other cells contain specific text

    Hello
    Please help me for this problem:
    In column A I have a time like
    8:40
    in column B I may have either "CL", or "LFT"
    I want to make column A value bold if time is greater than 8:30 and also
    1)IF Column B contains text other than "CL", or "LFT" or " "

    Best Regards
    Imran Bhatti
    Teach me Excel VBA

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,849

    Re: How to conditionally format cells if other cells contain specific text

    You can use this formula in the Conditional Formatting dialogue box for cell A1:

    =AND($A1>TIME(8,30,0),$B1<>"CL",$B1<>"LFT",$B1<>" ")

    Hope this helps.

    Pete

  3. #3
    Valued Forum Contributor ImranBhatti's Avatar
    Join Date
    03-27-2014
    Location
    Rawalpindi,Pakistan
    MS-Off Ver
    Office 365
    Posts
    1,759

    Re: How to conditionally format cells if other cells contain specific text

    Thank you very much Pete....I got the desired results with this...and thanks to format painter who pasted the formating to other rows.

    Thread is (SOLVED)

    Best Regards
    Imran Bhatti
    Last edited by ImranBhatti; 10-16-2016 at 02:39 PM.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,849

    Re: How to conditionally format cells if other cells contain specific text

    You're welcome - thanks for the rep.

    Pete

+ 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. if text is in specific format then file other cells with specfic text
    By Louisa Venter in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2016, 02:45 PM
  2. Replies: 1
    Last Post: 01-20-2016, 08:56 AM
  3. How to conditionally format cells using partial text
    By Cremorneguy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-26-2014, 11:26 AM
  4. Macro to Conditionally Format Cells based on another cells value
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-07-2013, 03:05 AM
  5. Replies: 6
    Last Post: 02-16-2013, 05:12 AM
  6. [SOLVED] Conditional Format Based on specific text in 3 different cells
    By tradersteve in forum Excel General
    Replies: 5
    Last Post: 11-08-2011, 06:49 AM
  7. Selecting cells that contain text in a specific format
    By nicad_adam in forum Excel General
    Replies: 1
    Last Post: 06-17-2005, 01:05 AM

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