LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number format question BobK Excel Discussion (Misc queries) 2 October 24th 08 08:12 PM
* next to date format in Formatcells Number tab Marco18+ Excel Discussion (Misc queries) 6 April 5th 06 08:40 PM
Simple Question, display only part of a date in Number format DB Explorer Excel Worksheet Functions 6 March 17th 06 11:47 AM
Excel: I enter date and format for date, but shows as number spohar Excel Discussion (Misc queries) 2 March 10th 06 08:40 PM
Custom Number format question Joh Excel Discussion (Misc queries) 5 October 25th 05 02:31 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"