Custom dat & time code

[Wuddus]

Does anyone know if it's possible write a custom cell-format code that
would look like the one Excel provides (mm/dd hh:mm AM/PM) but sets the
time in red? I've tried "mm/dd [RED]hh:mm AM/PM," but whenever I save it,
Excel moves the red bracket to the beginning of the code so the whole thing
is red. Help! Any ideas?

 

[Dave Peterson]

I don't think you can.

You can't format formulas like this (character by character).

And you can't format numbers this way, either.

(Anyway, I couldn't do it.)

Does anyone know if it's possible write a custom cell-format code that
would look like the one Excel provides (mm/dd hh:mm AM/PM) but sets the
time in red? I've tried "mm/dd [RED]hh:mm AM/PM," but whenever I save it,
Excel moves the red bracket to the beginning of the code so the whole thing
is red. Help! Any ideas?