# IF / THEN over my pay grade

1. ## 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. ## 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.

3. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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.

9. ## Re: IF / THEN over my pay grade

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

10. ## 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

11. ## 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. ## Re: IF / THEN over my pay grade

Rick, glad I was able to help, AND thank you for the rep!

13. ## 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.

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