+ Reply to Thread
Results 1 to 13 of 13

IF / THEN over my pay grade

  1. #1
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    IF / THEN over my pay grade

    I would like to have a If then format a cell Yellow.

    If L2 is blank then do nothing. If F2 has any data, then format B2 and C2 YELLOW. If that possible?

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.86 for Mac MS 365
    Posts
    8,545

    Re: IF / THEN over my pay grade

    I don't understand why you are mentioning L2 unless that has relevance to what to do with B2 and C2, that part of the explanation is unclear.
    for this part...
    If F2 has any data, then format B2 and C2 YELLOW
    use this in B2 under CF =F2<>"" then pick the fill as yellow, use the same in C2.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: IF / THEN over my pay grade

    L2 might or might not have data. There is a dropdown list for each cell in L column. So if there is data there I want to have B2 (First Name and C2 Last name highlighted Yellow. If there is NO DATA in L2 then do nothing.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.86 for Mac MS 365
    Posts
    8,545

    Re: IF / THEN over my pay grade

    Sorry, I'm still a little unclear as to what relationship you want L2 and F2 to have for fill for B2 and C2 so I'm going to give you two options that MIGHT cover what you want...
    =AND(F2<>"",L2<>"") and pick yellow fill OR option 2...
    =OR(F2<>"",L2<>"")
    maybe one of those will work, unless you want one to override the other?

  5. #5
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: IF / THEN over my pay grade

    Sorry for the miss spelled F2. That should have been L2. My old age fingers shake too much. I hope your wife is doing OK. What a cross to bear.

  6. #6
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.86 for Mac MS 365
    Posts
    8,545

    Re: IF / THEN over my pay grade

    Thank you, I appreciate the thoughts. She has progressed to the part where I'm answering questions on this forum to keep my mind active, and feeding her, but she has been the love of my life since high school and for 46 years.
    Soooo, anyway, can you adjust one of the formulas I gave you to suit your needs for L2 or is the problem still unsolved?

  7. #7
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: IF / THEN over my pay grade

    Oh I'm so sorry. I hope you have Christ in your life to give you strength and PEACE in there days. We are very close. My wife is my HS Sweet Heart of 52 years. I don't think I could survive wo her. Ya it's still unsolved. This stuff is greek to me unless I see an example in my data to understand the syntax. BTW we'll prat for you both.

  8. #8
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.86 for Mac MS 365
    Posts
    8,545

    Re: IF / THEN over my pay grade

    Nothing to be sorry about, and we do.
    So let me restate your problem without the "typo" in it if I'm understanding it.
    If L2 is blank, do nothing, if L2 has any data in it then format B2 and C2 as yellow.
    so this in conditional formatting in B2 and same in C2...
    =L2<>""
    attached is a mockup
    delete the text in L2 to see how B2 and C2 change.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: IF / THEN over my pay grade

    That's smooth. But I cant see where you hid the formula?

  10. #10
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.86 for Mac MS 365
    Posts
    8,545

    Re: IF / THEN over my pay grade

    Ok, so you need the basics. With your cursor being in cell B2, at the top of your workbook are different tabs. You want to be on the home tab.

    Over to the right side should be (above the fx window) you should see conditional formatting (CF) as an option. Click that. A window should appear. Now, mine in excel for Mac is a bit different than excel for microsoft but it should be close enough.

    In the one I posted when you click the CF dropdown it should give you a couple choices, they would be new rule, clear rules and manage rules. For mine you would look at the manage rules but for a new sheet you pick New Rule. New Rule would give you options to pick from color scales to classic (which is what I selected). Classic gave me another box with a dropdown that I could pick to use a formula to determine which cells to format - that is what I used, so you wouldn't see a formula in the cell itself.
    That is where I put the formula, so it doesn't appear in B2, it runs in the background and will activate depending on what is in or not in L2.

    If you look at mine, click in cell B2, go to CF, hit the dropdown and go to manage rules and a box will open showing you the formula for that cell, if you want to look at it more detail (there isn't really much more to look at) click on edit rule at the bottom and it will show you the formula. If you don't want to change it just click cancel or ok, ok again and the box will close.

    Here is a link that may be of help
    https://www.wikihow.com/Apply-Condit...tting-in-Excel
    Last edited by Sam Capricci; 10-02-2021 at 07:51 PM.

  11. #11
    Registered User
    Join Date
    11-12-2018
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    22

    Re: IF / THEN over my pay grade

    Da I knew I was over thinking that. I use CF alot. I looked at that too. But couldn't figure out the syntax. thanks.

  12. #12
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.86 for Mac MS 365
    Posts
    8,545

    Re: IF / THEN over my pay grade

    Rick, glad I was able to help, AND thank you for the rep!
    Last edited by Sam Capricci; 10-03-2021 at 02:15 PM.

  13. #13
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2407 (Windows 11 23H2 64-bit)
    Posts
    84,036

    Re: IF / THEN over my pay grade

    Please make an effort to use better thread titles in future - this one is too generic and tells us nothing of the actual issue. See the forum rules, please.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ 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. Conditional formatting target grade against actual grade
    By skardi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-10-2015, 01:58 PM
  2. Replies: 5
    Last Post: 11-30-2013, 01:28 PM
  3. What grade do I have to get on Final Exam to make a certain grade?
    By Catherine01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-15-2013, 05:28 PM
  4. Replies: 5
    Last Post: 02-17-2013, 03:29 PM
  5. Conditional formatting to reflect exam grade compared to predicted grade
    By strangecharm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-20-2012, 09:33 AM
  6. Student grade inputting and grade percentage calculations
    By confusedteacher in forum Excel General
    Replies: 2
    Last Post: 10-23-2011, 07:50 PM
  7. Macro To Change Letter Grade To Number Grade
    By florinel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-29-2008, 11:14 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