Thread: Conditional formatting with formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron@Buy Ron@Buy is offline
external usenet poster
  
Posts: 345
Default Conditional formatting with formula
Try:
=AND(A10<TODAY(),A10=TODAY()-30)


"CClark" wrote:

What formula would I use if I wanted to format a cell (say in red) if the
date entered in that cell is 30 days or less from today's date?
Reply With QuoteReply With Quote