Custom dat & time code
 

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

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.)



Wuddus wrote:

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