HELP DATE and Conditional Formating

[Florence1550]

HELP
User puts dates or Pastes Dates in to a Column
If the Date is Less then 7 Days from Todays date then Change Flas Cell
ID the Date in Cell is already past then Flash the row

Is this Possible This is to remind me of MOT and Vehicle inspection Dates
Also is there a way of Copy and Pasting Conditional Formating

I am new to excel but used to use Access but it seems in my office every one opens A spreadsheet

THanks

 

[Brianwarnock]

I don't know how to Flash rows or cells but you could change the colour, use the answer wizard (not the index) to look up conditional formatting in Excel Help, it will also tell you how to use the format painter.

Brian