+ Reply to Thread
Results 1 to 3 of 3

Conditional Format - Highlight Month Column Based on Cell value

  1. #1
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,683

    Conditional Format - Highlight Month Column Based on Cell value

    Hi,

    I have a user defined filed which the user enters a month in cell C5.

    I would like the data tables to be highlighted if the month matches the value in C5.

    In the example the reporting month is May and so the May columns of the data tables are highlighted.

    Can anyone help me do this please?

    Paul
    Attached Files Attached Files

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Conditional Format - Highlight Month Column Based on Cell value

    Hi,

    Please use the following formula in conditional formatting window. Sample attached.

    =MONTH(C$9)=MONTH($C$5)
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    04-21-2005
    Location
    Southern England
    MS-Off Ver
    Excel for Office 365
    Posts
    1,683

    Re: Conditional Format - Highlight Month Column Based on Cell value

    Perfect - thanks for this!!

+ 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: 12
    Last Post: 11-08-2013, 12:37 PM
  2. [SOLVED] Conditional Format to highlight cell based on corresponding date..
    By Vikestand in forum Excel General
    Replies: 4
    Last Post: 07-24-2013, 10:48 AM
  3. Replies: 6
    Last Post: 07-02-2013, 10:29 AM
  4. Replies: 2
    Last Post: 06-06-2013, 01:10 AM
  5. Conditional Format - Highlight based on the bottom row
    By MadCrammer in forum Excel General
    Replies: 2
    Last Post: 08-24-2010, 12:52 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