1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel help pls

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

  1. Diddums

    Capodecina

    Joined: Oct 24, 2012

    Posts: 14,872

    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

    Commissario

    Joined: Nov 23, 2004

    Posts: 33,098

    Location: Malmö

    Like this?

    [​IMG]

    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

    Capodecina

    Joined: Oct 24, 2012

    Posts: 14,872

    Location: London



    Voodoo. Cheers dude :)
     
  4. GIBURROWS

    Mobster

    Joined: Jan 13, 2010

    Posts: 2,630

    Location: The 'Shire'

    I LOVE EXCEL!!!

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