If you attempt to set the text RGB colour inside an IF statement in a formula, the default output is black.
Providing just the RGB() function inside a formula works OK, but not inside the IF statement.
Refer example appĀ 125270 for more details.
Bruce