Excel help pls

[Diddums]

From what I understand we have a fair few Excel pros on here, here's hoping one of you guys can help me out.

I'm making a todo list on Excel with various tabs for various items (fire systems, water systems, cleaning, etc).

In a cell I'll add an item which needs doing, in the next cell I want to add date raised, the next cell will allow me to input weeks which will add a date automagically, and colour the entire row based on time remaining.

Is this possible? This is probably a noob question for most of you but my Excel skills are woeful.

Cheers

 

[Maccy]

Like this?



If so, the formula in the last cell is =B3+(C3*7)

To do the coloured rows, you just use conditional formatting based on current date against date in the cell and have a rule for number of days remaining. Something like if difference is <=5 then colour me red, <=10 colour me yellow etc.

 

[Diddums]

Like this?



If so, the formula in the last cell is =B3+(C3*7)

To do the coloured rows, you just use conditional formatting based on current date against date in the cell and have a rule for number of days remaining. Something like if difference is <=5 then colour me red, <=10 colour me yellow etc.

Voodoo. Cheers dude

 

[GIBURROWS]

I LOVE EXCEL!!!

I am now trying to find out if there is something I could use this for....