Thread: What excel formula highlighs cells according to current date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default What excel formula highlighs cells according to current date
You can use Conditional Formatting. See:


http://www.contextures.com/xlCondFormat01.html
--
Gary's Student


"Al" wrote:

I would like to flag certain rows of information on an excel spreadsheet
according to current date. i.e. flag certain invoices 2 weeks before due
date. What formula can be used to acheive this?

Thanks.
Reply With QuoteReply With Quote