View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.newusers
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Showing time as minutes

In article ,
LurfysMa wrote:

Why does that custom formatting work? I thought the brackets were for
conditional formatting?


Brackets can be used in custom (not conditional) formats, e.g.,

[Red][<-100]-0;[Yellow][<0]0;[Green]0;@

Where is this documented?


XL Help "About custom number formats"