Replies

Maudibe,

Awesome; I cannot thank you enough. I don’t do a lot with Excel; but I know if I ever need help, someone has the answer(s). This is such a great community and I really appreciate the support I always receive.

I had a feeling that would be the case. I really appreciate you taking the time and effort to help me.

RetiredGeek / zeddy,

I’ve attached the workbook. I’ve also included a screen shot. I’m sorry for the changes, I’m trying to help a family member and they think since I can turn on a computer, I’m an expert…..at this point, I think there’re set with their layout/format.

Basically, I have columns A & B and F & G applying the correct conditional formatting based on RetireedGeek’s solution. It may not be possible, but I would also like to include columns J & M into the same conditional formatting rule without creating a second rule.

45421-CF

RetiredGeek,

Thank you, that’s exactly what I needed. Although, to be honest I will need to study this a little to make sure I completely grasp the concept.

After I posted my message, my layout changed a little. I have inserted 5 new columns (between D and E). None of the new columns would not have any conditional formatting, so I not sure what impact this would have on the solution you provided. It’s going to be later this evening before I can test it using my new layout. I will make sure I to take a close look at the new ranges that I apply the Conditional Formatting too.

Again, thank you for your help.

RetiredGeek

Thanks for your help. Your formula worked perfectly.

Maudibe,

Thank you for the code; it’s exactly what I was looking for. I have a followup question. I’m writing my first VBA code and noticed I could use your code without the preceding me. (e.g., Frame1.ForeColor = vbRed) and get the same results. What is the advantage of using the me. or disadvantage for not using it?

Again, many thanks.

zeddy,

Thank you for the suggestions; I used the following formula and got the results I was looking for:

=SUMIFS($E2:$E$11,$B$2:$B$11,”>=1/1/15″,$B$2:$B$11,”<=06/30/2015",$C$2:$C$11,"=RED", $D$2:$D$11,"CCA")

One other questions concerning the date range (year). I will reuse the worksheet each year, so I will need to adjust/update the formula according (e.g., replace 2015 with 2016 next year). Is it possible to substitute something for 2015 so that I don't have to modify the formula every year?