Excel 2007 : Conditional formatting for particular month

[jawalkar_renuka]

how to use conditional formating for 2 month(april and may)

[Mallycat]

Are you serious? Please provide more information. Perhaps post a sheet showing where your data is and how you would like it to be formatted and under what conditions

[jawalkar_renuka]

i have list of 10000 employees with their date of retirement. i want to use conditional formating to highlight the employees are retireing this month and next month

[SpreadSheetNinja]

If you have a sample sheet to show its easyer to be more exact, but im guessing you just need something like this in your formula
=TEKST(DATO(ÅR(NÅ());måned(nå());DAG(NÅ()));"m") (norwegian my version)
=text(date(year(now());month(now());day(now());"m") this will show up as month 4, so basicly you just do the check by conditional formating to
=and(text(date(year(now());month(now());day(now());"m")=4)
err, forget if english excel use , instead of ; so ill post it incase
=and(text(date(year(now()),month(now()),day(now()),"m")=4)

so if its currently month 4 now then it will show up as color
aka april = 4 just switch out the number for any month.. again im just guessing what your trying to ask for.

[SpreadSheetNinja]

and if its date retirement i guess the forumula would be if date x - date y = a negative number then true ect.. from respected cells. i cant guess how you write the dates but it would be that simple then

[jawalkar_renuka]

thanks for ur reply
but i can't understand where should i put this formula.

[Fotis1991]

Ηι

Pls, upload a sample workbook and i think you will find your solution...

[SpreadSheetNinja]

ah, your not looking for the actual formula your just wondering where to make the formula.

Well if you got Excel 2007+ then there should be a conditional formula tab ( i got the norwegian edition so its probebly written differently in english than what im saying), anyway in the conditional formula window that appears onec you find the conditional formula tab or button, then you wana look for create new rule, and then chose to use a formula to decide, basicly conditional formula only use true or false to determine when to run the color scheme you setup.

[SpreadSheetNinja]

also if you got older excel, i think you can only use up to 3 conditional color schemes or something like that.. while they removed that limit on 2007+