Thread: i need the date to flag up red if it goes over 30 days from the d.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default i need the date to flag up red if it goes over 30 days from the d.
Use conditional formatting on your date cell

Cell value is - Less than - ="today()-30"

Mike

"Pali" wrote:

i need the date to flag up red if it goes over 30 days from the date it was
logged
Reply With QuoteReply With Quote