Conditional Formatting: Pattern Recognition

Hello,

I'm having trouble with excel noticing a pattern with my sheet. I'm using the "Highlight Cell" rules, if it finds a Date between the dates of B3:C3, then it would search the entire Row 3 and highlight cells inbetween those dates. The Conditional Formatting system is working fine, and it works for Rows 3-7.

But if I set up those Rows, and try to make that the 'standard' for all below rows, Excel will not recognize the pattern for all cells below Row 7. I want excel to follow the same rules that Rows 3-7 are doing. If I copy that to Row 8-13 (B8:C8, B9:C9, B10:C10, ect), it will Highlight the Data for Rows 3-7 (B3:C3, B4:C4,B5:C5, ect).

Since I'm looking at doing this for about 300+ rows, manual entry will be time consuming. I don't usually have issues with Excel recognizing patterns when copying cells. I'm not sure why it would think I'm trying to find Data in Row 2 to fill in Row 10.

Thank you

Problem solved, I found the solution. In the Conditional Formatting, I needed to put =$B6 instead of =$B$6.

Welcome to the forum! Thank you for coming back to share the solution with us.

Since your question is now solved, please mark this thread as SOLVED.