+ Reply to Thread
Results 1 to 12 of 12

Changing cell values based on other cells values

  1. #1
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Question Changing cell values based on other cells values

    Hello everyone,

    I am attaching an excel file, I'm trying to figure out how to change the values of other cells based on the input of the previous ones.

    In the example attached, I managed to conditionally format and change the cell values in E5 based on the input of the previous cell if it is >= 60 it will change to green and the letter will change to C (Completed) If it is <=59 it will turn to Red and the letter will change to "F"

    What I need is to change the letters in cells G5 and I5 to "S" if the value in E5 is "C" and so on for the whole row, here I just included 3 stages but the stages could be more in the row.

    Thank you.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,873

    Re: Changing cell values based on other cells values

    I don't think you have explained this fully...


    but for openers:

    =IF($E5>=60,"S", IF(F5<=59,"F",IF(F5>=0,"R",0)))
    Attached Files Attached Files
    Glenn



  3. #3
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Re: Changing cell values based on other cells values

    Yes I guess I didn't explained it well,

    I will get back with a more detailed explanation and another clearer excel example.


    Thanks a lot for helping

  4. #4
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Re: Changing cell values based on other cells values

    Ok here is another file, this is more clear :D

    The only problem is when the cell is blank is not working!


    this is the formula I used but not working with empty cell


    =IF(A1>=60, "C", IF(A1<=59, "F", IF(A1="", "S")))

    Thanks for your time
    Attached Files Attached Files
    Last edited by BassemCh; 01-08-2021 at 12:48 PM.

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,873

    Re: Changing cell values based on other cells values

    That's not such an issue:

    =IF(A1="","",IF(A1>=60, "C", IF(A1<=59, "F", IF(A1="", "S"))))

  6. #6
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Re: Changing cell values based on other cells values

    Thanks Glenn, but still not working when the A1 is Empty, the B1 is not displaying an "S"
    Unless there is something that I have missed here

  7. #7
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,873

    Re: Changing cell values based on other cells values

    ??? see sheet
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Re: Changing cell values based on other cells values

    I'm sorry, but when A1 is empty with no value, the B1 is empty as well and not showing anything at all! I just tried the sheet. thanks

  9. #9
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Re: Changing cell values based on other cells values

    Ok I found out the issue here

    =IF(A1="","S",IF(A1>=60, "C", IF(A1<=59, "F", IF(A1="", "S"))))

    The S is missing in the 1st statement

  10. #10
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Re: Changing cell values based on other cells values

    Now this works: =IF(A1="","S",IF(A1>=60, "C", IF(A1<=59, "F")))

  11. #11
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,873

    Re: Changing cell values based on other cells values

    I think I misunderstood what you meant when you said:


    this is the formula I used but not working with empty cell

    I guessed what you meant by the bit in red... as you did not explain what "not working" meant...

    as long as you're sorted now.

  12. #12
    Registered User
    Join Date
    12-17-2020
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    34

    Re: Changing cell values based on other cells values

    No problem, you already helped me sort it out, thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Changing color format in cells based on 3 range values in a different column cells.
    By konkonmike in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 07-08-2019, 08:11 AM
  2. Replies: 1
    Last Post: 12-09-2018, 10:32 AM
  3. Replies: 2
    Last Post: 12-05-2016, 10:59 AM
  4. [SOLVED] Generating values in number of cells based on adjacent cell values
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2014, 04:34 PM
  5. [SOLVED] Sheet Change Event Dubuggin: Restrict Cell Values toand Changing cells based on input
    By cmore in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 10-28-2013, 02:37 PM
  6. Continuous changing cell values - record highest and lowest values in seperate cells
    By attienel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2013, 05:12 PM
  7. changing cell color based on changing values
    By tvonbehren in forum Excel General
    Replies: 2
    Last Post: 09-16-2009, 12:33 PM

Tags for this Thread

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