CF for next month/this year
Change today() to DATE(YEAR(Today()),MONTH(Today())+1,1)
--
David Biddulph
"computexcel" wrote in message
...
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.
|