Variable Field Name Formatting

[rizlaalzir]

Hi there, can I use the conditional formatting using a variable as part of the field name. The example is:- I have quite a complex set of conditional formats and I want to write a formula which takes account of part of the field name:

I have "field 1" to "field 53"

I want to have a formula to read something like this:-

if(GLOBAL NUMBER>rightwords(getactivefieldname);1);colour blue;colour red)

Can that be done? Or something like that? Or a custom function? I am sure it is easy, but I'm blowed if I can find how to do it! Thanks in advance.

[LaRetta]

A bit more information would help. But I would propose that 'I have "field 1" to "field 53"' indicates those might work better as related records because it sounds like they all serve similar purpose?

[comment]

If the field is active, conditional formatting will not be applied to it.

[rizlaalzir]

Oh.... well thanks for your quick responses anyway