Excel Formula Needed

Steps to Apply Conditional Formatting:

1. Select the Relevant Cells:
• Highlight the cells where you want to apply this formatting (e.g., the dates of tasks).
2. Open Conditional Formatting:
• Go to the Home tab, and in the Styles group, click on Conditional Formatting. Then, choose New Rule.
3. Create the Rules for Each Time Range:

Rule 1: For Green (6-6.99 months)

• Select "Use a formula to determine which cells to format."
• Enter the following formula (assuming the task dates are in column A and start in row 1):
• =AND(TODAY() - A1 >= 182, TODAY() - A1 < 213)
• Explanation: 182 days (approx. 6 months) to 213 days (approx. 7 months).
• Click Format, choose a green fill color, and then click OK.

Rule 2: For Yellow (7-9.99 months)

• Add a new rule.
• Formula:
• =AND(TODAY() - A1 >= 213, TODAY() - A1 < 304)
• Explanation: 213 days (approx. 7 months) to 304 days (approx. 10 months).
• Click Format, choose a yellow fill color, and then click OK.

Rule 3: For Red (10-12 months)

• Add another rule.
• Formula:
• =AND(TODAY() - A1 >= 304, TODAY() - A1 <= 365)
• Explanation: 304 days (approx. 10 months) to 365 days (approx. 12 months).
• Click Format, choose a red fill color, and then click OK.
1. Finalize and Apply:
• Click OK to close the Conditional Formatting Rules Manager. Your task cells should now dynamically change colors based on the time elapsed.