CF for next month/this year

C

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.
 
S

smartin

computexcel said:
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.
Click to expand...


=DATE(YEAR(A3),MONTH(A3),1)=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)
^^

Works across year-ends as well.

Adjust the bit above ^^ to make this relative to any number of months.
 
C

computexcel

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

smartin

computexcel said:
Like my cat says "Purrrfect".All three formulas.
Thanks smartin, David and Max
you are very kind.
Click to expand...

Glad you found an answer.

My cat says "mwraowwwwr?", but he's a little touched.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
Conditional Formatting in Excel 2003 2
Formula for Dates and CF Colour then convert to Text 3
CF for Text 2
Conditional formatting with two columns 0
Conditional Formating based on Date 5
Formula for CF to color current month 2
changed DOB to age, but if no DOB need cell to be empty. 4

Top