View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default format number-date question

Hello,

without the use of conditional formatting, is it possible to format the date
turn red font if it is before today().

same like when numbers are treated as negative.

something like...
[red if < today()] dd-mmm-yy

regards,