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
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