Excel - problem with conditional formatting

Posted on 2011-04-21
Last Modified: 2012-05-11
I have a problem with some conditional formatting.  The attached spreadsheet should describe the problem.
I want to have a list of 5 workdays (B2 to B6).  Next to those are cells that can be selected with an "x".

Below in the spreadsheet is a list of dates (B10 to >>>>)

I simply want to bold up the dates in the list if their corresponding weekday in the top list is ticked (ie an "x" in the adjacent box).

I just cannot get it to work properly.  In the spreadsheet, Tuesday and Wednesday work fine, Thursday and Friday don't work and Monday bolds up Saturday, Sunday and Monday!!

It's driving me nuts and I'm sure it's just a simple mistake or lack of understanding.

The formulas in columns D and E are just debug (and there seems to be a fundamental problem with Friday!!)

Hope someone can throw some light on it.

Best regards

Question by:rltomalin
    LVL 11

    Accepted Solution

    try this formula;

    LVL 11

    Expert Comment

    The erroneous results you are getting are a mystery and appears to be a bug!
    LVL 18

    Assisted Solution


    LOOKUP works only if your data is sorted. Another option would be



    Author Closing Comment

    Hi Guys

    Thanks for that.  Both solutions seem to work fine - so I will split the points.



    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
    Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now