Hi,

I've been scratching my head for hours trying to work out what is going wrong.

I want to format a cell conditional on the value of another cell. I have read numerous threads on the topic and no matter what I do, it doesn't seem to work for me. I've made it a simple as possible by creating a new workbook and entering:
A1: 5
B1: 2
C1: Some random text - this cell has the conditional formula: ="A1>B1"

However, the cell doesn't get formatted.
Here is a screenshot and here is the simple workbook.

Any ideas?

Thanks