Hi All,
A simple question; I presume there is a rule that states that if you format a cell dependent upon whether it contains text (=ISTEXT(cell_ref)) and that cell has formula, Excel assumes is has text because of the formula and therefore formats it anyway? I attached an example file.
Bookmarks