Forum Discussion
Solved
Advanced Conditional Formatting?
Hello, I am looking to create a table with a list of individuals who have completed a specific training and have received a certificate for it. Let's say for example it is CPR Training. I visual...
Hi Fyse,
Select your dates, in ribbon Conditional formatting, New rule, Use formula...
Add formula
=(EDATE($H5,24)>=TODAY())*(EDATE($H5,21)<=TODAY())
and apply yellow format
Ok and apply
Repeat Conditional formatting -> Manage rule, New rule, etc, but with formula
=(TODAY()>=EDATE($H5,24))
Result is like this
and attached.
Sorry, I was wrong with previous variant of formulas, corrected.
Hi Fyse,
You may apply conditional formatting rule like
=(EDATE(<date>,24)>=EDATE(TODAY(),-3))*(EDATE(<date>,24)<=TODAY())
for yellow color and
=(EDATE(<date>,24)>=TODAY())
for the red one
Hi Sergei,
Thanks for the reply, I really appreciate it. However, I am still unsure of how to continue with this.
Could you see the attached example file and help me out?
Much apprecaited,
Fyse
Hi Fyse,
Select your dates, in ribbon Conditional formatting, New rule, Use formula...
Add formula
=(EDATE($H5,24)>=TODAY())*(EDATE($H5,21)<=TODAY())
and apply yellow format
Ok and apply
Repeat Conditional formatting -> Manage rule, New rule, etc, but with formula
=(TODAY()>=EDATE($H5,24))
Result is like this
and attached.
Sorry, I was wrong with previous variant of formulas, corrected.
Hi Sergei,
For the longest time, I couldn't figure out why I was not getting any yellow boxes. I realized in my dates, I did not leave an example for a yellow cell. But, you adjusted the date to show it. Everything works perfectly! Thank you so much for this, I appreciate it!
Fyse
