Excel help pls

Diddums

Diddums

Diddums

Caporegime
Joined
24 Oct 2012
Posts
25,687
Location
Godalming
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 :)
 
Like this?

4w4hfRS.png

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.
 
Maccy said:
Like this?

4w4hfRS.png

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.
Click to expand...



Voodoo. Cheers dude :)
 
You must log in or register to reply here.
Back
Top Bottom