Results 1 to 6 of 6

Changing a formula in a cell by entering a number in another cell, is it possible?

Threaded View

  1. #5
    Registered User
    Join Date
    01-28-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2013 (PC)
    Posts
    27

    Re: Changing a formula in a cell by entering a number in another cell, is it possible?

    Thanks again, appreciate your time.

    The idea is if i enter 43 (for example) in to B20, then B22 would turn Green within 5 either side of 43 (range 38 to 48)
    It would turn Amber within 13 either side of 43 (range 30 to 37 and 49 to 56)

    What I'm hoping is to enter any value in to B20 and it would follow these sets of rules in B22

    Sorry if I'm not being very clear.
    Last edited by suxrule; 06-20-2012 at 08:34 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1