+ Reply to Thread
Results 1 to 4 of 4

If cell contain text, conditional formatting multiple cells

  1. #1
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    If cell contain text, conditional formatting multiple cells

    Frequent used: =$C6="Monthly"
    excel.png


    possible to do as below?
    When monthly selected, conditional formatting (fill) as below
    m.png

    When weekly selected, conditional formatting (fill) as below
    w.png

    When halfyearly selected, conditional formatting (fill) as below
    h.png

    When quarterly selected, conditional formatting (fill) as below
    Attached Images Attached Images
    Last edited by amein; 05-06-2016 at 05:13 AM.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: If cell contain text, conditional formatting multiple cells

    Post a sample file in excel format rather than an image. Images are impossible to edit and nobody wants to recreate the file for you.
    Attach a sample spreadsheet with expected results, remove any sensitive data.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    Re: If cell contain text, conditional formatting multiple cells

    UPDATE with excel file. Sorry.

    http://www.excelforum.com/attachment...1&d=1462525373
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    03-06-2014
    Location
    malaysia
    MS-Off Ver
    Excel 2003/2010/2013
    Posts
    107

    Re: If cell contain text, conditional formatting multiple cells

    Will TRY VBA solution. thanks. New thread will open later,

+ 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. Conditional Formatting (if MULTIPLE cells contain ANY text & not numbers)
    By Biscuit17 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-20-2016, 09:01 PM
  2. Replies: 6
    Last Post: 10-29-2015, 03:38 PM
  3. [SOLVED] Need to apply conditional formatting of a cell base on text in multiple other cells
    By Herkfixer in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-19-2013, 08:59 PM
  4. Replies: 2
    Last Post: 07-28-2013, 03:28 PM
  5. Replies: 3
    Last Post: 06-25-2013, 04:41 AM
  6. Replies: 3
    Last Post: 10-09-2009, 01:34 PM
  7. [SOLVED] Conditional formatting of adjacent cells based on text in cell
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2006, 07:20 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