View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default formatting cells with boolean values

I am not much on custom formats, but you could hide the column containing the
"true" or "false" and in the column that is displayed put a formula:

=If(A1=True,"T","F")
where A1 is the hidden column that contains "true" or "False". HTH.