Hi.
I'm new to this forum and english is not native language so bear with me.
I really try to figure out an easy way in excel to show me when a deadline is approaching.
So let's say I have a deadline 2022-01-31, and I type 2022-01-31 in a cell.
I want excel to turn the cell red when it reaches 2022-01-31 and keep showing red after 2022-01-31.
I also want excel to turn the cell yellow when it is 14 days left until deadline.
When it is more than 14 days left I want the cell to be green.
How do I do this in Excel? I have searched everywhere and I fail every time.
I know I can use "conditional formatting" but I do not know what formula to apply to make it work.
Thanks in advance.
I'm new to this forum and english is not native language so bear with me.
I really try to figure out an easy way in excel to show me when a deadline is approaching.
So let's say I have a deadline 2022-01-31, and I type 2022-01-31 in a cell.
I want excel to turn the cell red when it reaches 2022-01-31 and keep showing red after 2022-01-31.
I also want excel to turn the cell yellow when it is 14 days left until deadline.
When it is more than 14 days left I want the cell to be green.
How do I do this in Excel? I have searched everywhere and I fail every time.
I know I can use "conditional formatting" but I do not know what formula to apply to make it work.
Thanks in advance.