Results 1 to 4 of 4

If cell contain text, conditional formatting multiple cells

Threaded View

  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.

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 elderain@gmail.com 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