Macro Based on Cell Background Color

Hi all,

I'm looking to create a Macro that searches the defined ranges (Range1 to 75) in a sheet called "Layout" and if it has a red background then I want it to perform a Macro after users double click on the Range. The Macro will be to unhide rows on a second sheet called "Reports". I have a similar thread using checkboxes and a command button, but based on feedback from users; they'd prefer something different.

What I have so far is:

Please Login or Register  to view this content.

I'm not sure how to incorporate the double click part and i'm still working on the background.color = red selection property.

Difficult to test without real data but try something like this.

Please Login or Register  to view this content.

Paste into the appropriate sheet tab in the VBA editor.

Try this

Please Login or Register  to view this content.

This Post is a little different then my last as I have managed to get the macro to work based on background color i'm just having problems using variables within a range. The code I have so far is:

Please Login or Register  to view this content.

I have three rows of boxes so i'm going to repeat this formula three times and define more variables. I have had this code work with a defined range of:

Please Login or Register  to view this content.

but the problem i was having was that it would only unhide cells if the first cell in the first box had a red background regardless of if other boxes had red backgrounds. Any help is welcomed . I'd prefer not to use the double offset and have a formula for the row such as the one in the first CODE box.

The line

Please Login or Register  to view this content.

needs to be inside the loop otherwise the value of B does not change from its initial value of 0.