Thread: Date passed formula
View Single Post
  #2   Report Post  
bala_vb bala_vb is offline
Senior Member
  
Location: Hyderabad
Posts: 237
Thumbs up
Quote:
Originally Posted by sweetcorn999 View Post
Hi all,

I need to create a formula which highlights a row when todays date excedes a date set in a cell, for example, the date in cell 'A1' is 07.06.10 and todays date is 08.06.10, therefore row A is highlighted in red.

Any ideas?
try conditional formating,

use this formula in conditonal formatting and set color to red

=AND($A$1<TODAY())
__________________
Thanks
Bala
Reply With QuoteReply With Quote