How can I fill cells corresponding to two date values?

Helen Young 0

I'm trying to figure out a formula to fill cells with colour corresponding to date ranges and task to show Red, Amber, Green across a timeline.

Emi Zhang-MSFT 27,081 Reputation points Microsoft Vendor

2025-01-16T08:01:35.8033333+00:00

Hi,

Just checking in to see if the information of Barry Schwarz was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

1 answer

Barry Schwarz 3,236 Reputation points

2025-01-15T15:09:14.39+00:00

The common answer to this type of request is to use Conditional Formatting. One typical formula is

=AND(A1<TODAY()+60,A1>=TODAY()+30)

which will flag items due 30 to 60 days from today. There are similar formulas which will flag items based on how past due they are.

The more details you provide, the more specific our answers can be.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer