Change conditional formating with a formulae?

[joxorab]

In Cell A I have a Date in 1.1.2010.
If condition X applies I want to have it on Cell A2 in english format (January 2010), if condition Y applies, I want to have it on french format (Janvier 2010).

Is it possible to create a formulae that changes the formating?

[darkyam]

Not that I'm aware of, but you can do it with VLOOKUP. Put numbers 1-12 in a column, then Jan-Dec next to it and the French version next to that. Let A1 be the cell that determines which version and it can read "English" or "French". If A2 has your date, and the VLOOKUP table is in D1:F12, B2 can have =VLookup(Month(A2),$D$1:$F$12,IF($A$1="English",2,3),0).

Alternatively, you can put the months in without the numbers and use =Index($E$1:$F$12,Month(A2),IF($A$1="English",1,2))

[joxorab]

Thank's for your reply.

Works perfectly.

joxo