View Single Post
  #2   Report Post  
David Hepner
 
Posts: n/a
Default

Use conditional formatting

FormatConditional formatting


"Tessie" wrote:

I am working on a spreadsheet where I need column H to tell me when it has
been 90 days since the date in column G. I know how to do the
formula...=Gline#+(90); but I would like for it to highlight the box when the
date is past due. If anyone has any comments or helpful thoughts, please let
me know! Thanks so much!