It didn't work, I am trying to understand exactly what you mean in the second
choice. How do I format the cells as if the condition being met? Do I have to
replace (TheDate) with a range or date within the Brackets or replace an
actual 3 letter month for "mmm" like JUL or SEP? What is meant by -1,1? Maybe
I am putting it in wrong. note: I selected every second cell eg: JAN,MAR, MAY
etc....and then I typed in the second formula exactly as you have it then
selected blue as a color. I then selected FEB, APR, JUN etc.....and typed in
the second formula exactly as you had it in the second paragragh and selected
green as a color.

"John C" wrote:

If you want the highlighted cell to be the same color, no matter what, the
conditional formatting you would type in to C2 would be as follows:

=C2=TEXT(DATE(YEAR(TheDate),MONTH(TheDate)-1,1),"mmm")

Highlight cells C2 through C12, and go to Format|Conditional Formatting, and
press OK. This will copy all the conditional formatting for all the select.

Obviously, TheDate referenced above will be the date that you are basing
what you want highlighted.

A second choice, if you want DIFFERENT colors for each month if they meet
the criteria, to do this, first, format the cell(s) as if their condition was
met, then, the formula that would go in cell C2 would be the following:
=C2<TEXT(DATE(YEAR(MyDate),MONTH(MyDate)-1,1),"mmm")
And the formatting would be to clear out any colors you have their, leaving
ONLY the one that the criteria of the month before with it's "normal" state.



--
John C


"Loadmaster" wrote:

Cells C2:C13 has JAN - DEC. If todays month is between the 1 - 31 of Jan I
require the previous month €œDEC€� conditionally formatted with a color that I
specify from the color pallet. If todays month is between the 1-28 or 29th of
Feb I require the previous cell month €œJAN€� also conditionally color
formatted. As conditional formatting only allows you to set a maximum of
three conditions, how do I format all the months in C2:C13 the same way?