# Excel help pls

Discussion in 'HTML, Graphics & Programming' started by Diddums, Jul 18, 2018.

1. Diddums

# Location: London

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

2. Maccy

# Location: Back in Blighty

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.

3. Diddums

# Location: London

Voodoo. Cheers dude

4. GIBURROWS

# Location: The 'Shire'

I LOVE EXCEL!!!

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