Thread: Conditional formatting for range of cells?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Compass Rose Compass Rose is offline
external usenet poster
  
Posts: 30
Default Conditional formatting for range of cells?
Cells B2 to B150 contain dates. Is it possible to apply conditional
formatting to B1 so that it turns red if any of the dates in B2:B150 are
greater than TODAY()? If so, what is the formula?

TIA
David
Reply With QuoteReply With Quote