LinkBack URL
About LinkBacks
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?
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?
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...
use this in B2 under CF =F2<>"" then pick the fill as yellow, use the same in C2.If F2 has any data, then format B2 and C2 YELLOW
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
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.
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?
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.
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?
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.
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.
That's smooth. But I cant see where you hid the formula?
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.
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.
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.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks