C
C
CREWbig2020-02-17 20:57:32
excel
CREWbig, 2020-02-17 20:57:32

How can I make conditional formatting highlight the date when there are less than 2 months left from the current date?

Greetings! Help me figure it out! How to apply formatting conditions so that the cell color changes if less than 2 months remain from the current date to the specified date in the cell (applies as less than 60 days).
Found a rule where formatting is applied if less than a month is left (dates are in the next month)

Answer the question

In order to leave comments, you need to log in

1 answer(s)
L
lonelymyp, 2020-02-17
@lonelymyp

For formatting, you can use any
conditional formatting formula -> create a rule -> Use a formula to determine the cells to be formatted.
Write a formula that checks the condition, subtract the specified date from the current date and check that it turned out to be less than 60 days.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question