Excel help please

[Colbaker]

Hi all,

I am teaching myself excel and in order to do it I am giving myself problems and making up spreadsheets, my current spreadsheet involves a food expiry list,

Column a lists all the products expiry dates
Column b lists the product

What I want to happen is when it is 7 days before product expiry date then I want that row to conditional format red, I know a little of conditional formatting but can't seem to get it to work (it's has to stay red until I delete the whole lot), any ideas?

Now a more awkward issue, is there any way that along with the above conditional format, when this date reaches -7 days automatically transfer it to another page on the spreadsheet?

Thanks Lads

 

[wesimmo]

Highlight the cell you want to format, it's easiest to use the date cell, then add conditional formatting from the toolbar, depending on which version of excel you'll get options to highlight the cell if it's less then something.

Enter that "something" as =TODAY()+7.

Using formulas you could bring the items into another list, not transfer them as such, that would probably require VBA to automate fully.