| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
if statement depending on month
Fantastic! thought it would be much more complex.
Many thanks, Manuel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find last day of month depending on criteria | Excel Discussion (Misc queries) | |||
| Please help - subtotal using vlookup depending on variable month | Excel Discussion (Misc queries) | |||
| How do I add totals from a range of dates depending on the month? | Excel Worksheet Functions | |||
| Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
| posting data from a form to a sheet depending on month | Excel Programming | |||
Linear Mode
