need help with Conditional Formating

Discussion in 'Software' started by Arroryn, Nov 16, 2005.

  1. Arroryn

    Arroryn we're all dooooooomed Moderator

    I can do simple formating, but my manager has requested something a smidgeon more complex.

    They want a cumulative percentage on a spreadsheet that is sent out daily, for figure 'x'. But the person that updates this report is not very fluent with computers, let alone Excel. So that they don't have to update the formula every day, they want it so that the percentage column/row is blank until the day the figure is required.
    Certifications: A+, N+, MCDST, 70-410, 70-411
    WIP: Modern Languages BA
  2. moominboy

    moominboy Gigabyte Poster

    if you give a bit more info arroryn, then im sure i could ask my mate at work who is a whizz on excel, unless someone else knows?

    i'll get back in about half an hour.
    Certifications: ECDL
    WIP: A+
  3. moominboy

    moominboy Gigabyte Poster

    as i read it arroryn, you need a few cells/cell to be updated automatically with dynamic variables each day?

    but you can't really trust the end user to input them properly?

    we don't have any real idea to automate this but if you have an absolute address/reference which the formula would look in then you can hit CTRL-ALT-F9 to refresh all the open excel docs at once, from their respective absolutes.

    and maybe you could write a macro to actually input the data from Z into X cell?

    not really big on macros though...sorry!

    last resort, teach the guy to use excel?! :tongue
    Certifications: ECDL
    WIP: A+

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.