Color range of cells (specific number of them) as determined by different cell value

  • I have 2 sheets of data, one has every day of the year and people that selected that date for vacations. I have another sheet that determines what the limitations are for each day of year.


    I need to highlight the dates on sheet 1 that have more people selected than allowed - those limits are found on a different sheet. Hopefully that makes sense.


    I think I have to do a nested loop but I have no idea where to start. Thanks for the help!

  • Re: Color range of cells (specific number of them) as determined by different cell va


    Quote from Max1616;762298

    Could you post an example workbook?


    See attached. "Calendar" is the selections made (this will eventually be much more full of data) and the allotment for each date is on "Limit_Set"... so if there are more entries on the given date than what the allotment allows, then fill the shades red for those entries over the limit and make the entries that are within limit, fill with green.

  • Re: Color range of cells (specific number of them) as determined by different cell va


    Let me know if this works:


    Sincerely,
    -Max

  • Re: Color range of cells (specific number of them) as determined by different cell va


    I must have something severely screwed up because it's coloring a row on a completely different sheet... I'll PM you my entire workbook.

  • Re: Color range of cells (specific number of them) as determined by different cell va


    Try removing what I initially sent and add this:


    Before I assumed the calendar was your active sheet. This should fix that.

  • Re: Color range of cells (specific number of them) as determined by different cell va


    That works... however, not exactly what I needed. So your script changes the date heading to a different color. What I need is the grid below each date to reflect entries in and out of compliance. So get the limit from the limit_set sheet, then color all cells as pictured.


    [ATTACH=CONFIG]67823[/ATTACH]

  • Re: Color range of cells (specific number of them) as determined by different cell va


    That makes more sense! This is working for me:


    Let me know if that's what you wanted.


    Sincerely,
    -Max

  • Re: Color range of cells (specific number of them) as determined by different cell va


    Works perfectly! Thank you for your help... almost done with this project.


    I did have to add a worksheet select because it kept erroring out due to the macro being on the wrong sheet.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!