if statement depending on month
 

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

if statement depending on month
 

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" wrote in message
oups.com...
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

if statement depending on month
 

Fantastic! thought it would be much more complex.

Many thanks, Manuel