Conditional formatting not working from Excel to PDF

[lauranvh]

I found a weird bug when using Excel conditional formatting.

I made a Excel report that is transformed to a PDF document.

When i preview the document in Excel the conditional formatting is used and shown

It's a simple conditional formatting rule. When the data date is smaller than date today than the cell turns red.

But a problem arises when I preview it to PDF

The complete conditional formatting isn't shown anymore.

This also comes out this way when I start the task and output the report.

Anybody with the same problem, who can help me with a solution?

[lauranvh · Accepted solution]

A very late reaction but I just fixed this problem.

I used the NUMBERVALUE function in the conditional formatting rule. I changed it to the VALUE function and that works when i preview to PDF.

The precise conditional formatting rule is: VALUE(TODAY())

Very weird problem but it works.