+ Reply to Thread
Results 1 to 2 of 2

Highlight range cells based on category (conditional formatting)

  1. #1
    Forum Contributor
    Join Date
    01-17-2011
    Location
    amsterdam, Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    189

    Highlight range cells based on category (conditional formatting)

    I would like to highlight a range of cells with a certain color based on a few conditions
    Only cells between the start and enddate should be coloured. There are 4 categories which each should have a own color.

    I made an exmaple attached. Hoipe somebody can help me
    Attached Files Attached Files
    Last edited by keis386; 12-18-2019 at 10:21 AM.

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

    Re: Highlight range cells based on category (conditional formatting)

    Please try
    Conditional formatting applies to $D$2:$AG$9

    =($A2<D$1)*($B2>D$1-7)*($C2=1)

    Change 1 to 2,3,4
    Attached Files Attached Files

+ 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: 3
    Last Post: 06-08-2017, 07:31 PM
  2. Replies: 12
    Last Post: 01-26-2015, 04:18 AM
  3. Replies: 4
    Last Post: 11-18-2014, 04:12 AM
  4. [SOLVED] Conditional Formatting - highlight cells if range count = 0
    By VBA FTW in forum Excel General
    Replies: 2
    Last Post: 11-25-2013, 04:45 PM
  5. Using Conditional Formatting to highlight cells based on approaching dates
    By BrutalExcel in forum Excel - New Users/Basics
    Replies: 11
    Last Post: 06-12-2013, 11:56 AM
  6. Replies: 2
    Last Post: 06-06-2013, 01:10 AM
  7. Conditional formatting - highlight range of cells when it equals a cell
    By kingkong321 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 05:13 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