Conditional Formatting in Excel 2010

Hi everybody,

As i recently decided to migrate from MS Excel 2003 to MS Excel 2010, I'm puzzled by conditional formatting feature in Excel 2010.

As a translator, I've an activity worksheet that lists all requests for translation from my customers. This worksheet includes a number of fields:

Date
Client
Project
End Customer
PM/TL
PO#
Pre-counting Words/Total Words
Proofread/Working (hours/mins)
Delivered
Invoiced
Invoiceable Amount

In Excel 2003, I was able to set up conditional formatting for the column PO# which is for Purchase Order #s. Condition was if Project's name and Invoice# cells are not empty, then PO# cell was in light green background.

Here is my formula:
="AND($C1<>"""";$F1<>"""";$J1<>"""")=TRUE"
where $C1 is for Project's name,
$F1 is for PO,
and $J1 is for Invoice#.

This rule is applied to the whole column F:F.

When I'm sure the rule is working, I will later remove it for the first row which is the heading row.

This rule was working in Excel 2003 and is not any longer working in Excel 2010. Why?

I'm attaching a sample file (plse note that the formula is written in French where "ET" is for "AND" and "VRAI" is for "TRUE".)

Many thanks in advance for any clue.

Cheers.

Patrick
CondFormat-sample.xlsx