CF Help (2003 SP3)

[steveh]

Good afternoon

I have a cell that in certain conditions returns a 0, is it possible with a formula in CF to say that something like =IF(A1=0, "Monitoring Station Offline") or are you restricted to just font and cell colours?

Ta

[StuartR]

You can't do this with conditional formatting, but you can easily do it with a normal cell formula.

Edited by StuartR to add
A little experimenting shows that I was wrong!
You can apply a custom number format, that would replace any zero with "No value", see column I in the attached workbook.

[rory]

You don't even need CF for that. A simple number format of say:
#,##0;-#,##0;"Monitoring Station Offline";
will do it.

[steveh]

You can't do this with conditional formatting, but you can easily do it with a normal cell formula.

Edited by StuartR to add
A little experimenting shows that I was wrong!
You can apply a custom number format, that would replace any zero with "No value", see column I in the attached workbook.

Hi Stuart

Thank you for that but in the conversion from 2003 to 2007 it said it could not use the new CF features

[steveh]

You don't even need CF for that. A simple number format of say:
#,##0;-#,##0;"Monitoring Station Offline";
will do it.

Hi Rory

Excellent, thank you, hows the (probably not by now) little one?

[rory]

She's a wonderful handful, thank you! And definitely not so little any more.