So I have cells populated by dates that show only month and year (I'll use Feb-24 as an example of just one cell). I want all these cells to be:
1. Highlighted in green if the the date is more than 3 calendar months away. For example Feb-24 would be green today (October 31, 2023).
2. Highlighted in yellow if the date is within 3 calendar months away. For example a date of Feb-24 will turn yellow as of tomorrow (because Feb 2024 - 3 months = Nov 2023)
3. Highlighted in red if the date is today or in the past. So in the above example, January 31st of 2024 the cell would be yellow but on February 1st it would turn red.
My issue is I don't understand formulas well enough to have anything more than a simple if/then formula and this must have all three conditions applied at once. I assume it is an easy conditional for someone with a bit more knowledge so any assistance you can provide would be very much appreciated!
1. Highlighted in green if the the date is more than 3 calendar months away. For example Feb-24 would be green today (October 31, 2023).
2. Highlighted in yellow if the date is within 3 calendar months away. For example a date of Feb-24 will turn yellow as of tomorrow (because Feb 2024 - 3 months = Nov 2023)
3. Highlighted in red if the date is today or in the past. So in the above example, January 31st of 2024 the cell would be yellow but on February 1st it would turn red.
My issue is I don't understand formulas well enough to have anything more than a simple if/then formula and this must have all three conditions applied at once. I assume it is an easy conditional for someone with a bit more knowledge so any assistance you can provide would be very much appreciated!