if statement depending on month

[Grotifant]

Hi all,

I need to manipulate some data depending on the date in the column next
to it.

If the date is from the same month as the date in the row above then I
don't have to do anything but if the date is from another month then I
have to change the font of the number in the next column to bold.

Any help is greatly appreciated!!!!!!

Manuel

 

[Bob Phillips]

Conditional formatting with a formula of

=MONTH(A2)=MONTH(A1)

and format as bold

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Grotifant]

Fantastic! thought it would be much more complex.

Many thanks, Manuel