Conditional Formatting with Multiple Date critiera

Hi,

Yes! You can apply one conditional formatting rule to multiple rows dynamically using a relative reference in your formula.

Select the entire range where you want the formatting to apply.
Example: If your data starts in row 2 and goes down to row 100, select B2:C100 (assuming columns B and C contain task completion dates).
Go to Conditional Formatting → New Rule.
Select "Use a formula to determine which cells to format".
Enter the formula for Column B:

=AND(B2>=$A2, B2<=$A2+365)

This checks if the value in column B falls between the Start Date (A2) and A2 + 365 days.

5. Click "Format" → Choose a highlight color and press OK.

Repeat for Column C (Task 2), using this formula:=AND(C2>=$A2, C2<=$A2+365)

6. Click OK to apply the rule.

Now, the rule will apply to all rows dynamically without needing individual rules per row.

Hope this helps! Let me know if you need any adjustments. 😊