Formula or Conditional formatting?

[suzannemccarthy1984]

I have a spreadsheet with dates in column D, I want it to be able to highlight the cells if the date is over 15 days old, and there is nothing in column E.

Really not sure where I need to start with this, as to if its a formula or conditional formatting.

[Richard Buttrey]

I you want the cells to be highlighted then you'll need a cond. format. If you just want to mark an adjacent cell with something then a formula.

For the cond.format in D1 put

Please Login or Register  to view this content.

and format the cell with whatever colour / font you want. Apply this to all the column D cells

To mark a cell in say column F the formula is much the same

Please Login or Register  to view this content.

[suzannemccarthy1984]

Thank you so much for your help - much appreciated

[Richard Buttrey]

My pleasure and thanks for the rep.