CF for next month/this year

[computexcel]

I recently got this formula from Dave, thanks :
=text(A1,"yyyymm")=text(today(),"yyyymm")
to use it in conditional formatting and color RED all dates for this month.
Now I need the "contraparte" for another worsheet :
CF to color GREEN all dates for next month, today is October, next month will
be November, Etc. Autoupdating like the above formula does.
THANKS in advance.

 

[Max]

.. CF to color GREEN all dates for next month ..

Think you could try:
=TEXT(A1,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+1,1),"yyyymm")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---

 

[computexcel]

Like my cat says "Purrrfect".All three formulas.
Thanks smartin, David and Max
you are very kind.

 

[Max]

Welcome, thanks for feeding back.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800, Files:359, Subscribers:56
xdemechanik