View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt D Francis Matt D Francis is offline
external usenet poster
 
Posts: 13
Default Conditional Format <=Today()

Hello

I want to apply conditional Formatting to a range of cells dependant on the
current date. All cells are formatted and populated with dates, and I simply
need them to aplly formatting based on whether the date is <= the present
date.

I've tried

Formula Is <=today()

but thinks it's text and chnages it to

Formula Is ="<=today()"

So how do I do it?

Matt