Posts by redrocker1200

Beautiful! Thank you.

Hi KjBox, Very cool and thank you. I have a lot to learn. I am wondering if there is a way to color the empty cells with the lighter color also. The "vbNullString" does not seem to do it. I appreciate it.

Thank you for looking at my question. Attached is a file that has some Conditional Formatting on Columns C and D that is tied to the values in Column F which creates groups with two different shades of yellow. The values in Column F are determined by a formula tied to cell J1 that creates either groups of 4 or groups of 3, depending on which radio button is selected. There are some other macros that for some reason changes the priority of the two formulas in Conditional Formatting. So am trying to control it with VBA. The macro "color_rows" is based on a similar macro that I found online, but it does not work. The formula with top priority should is determined if the value in Column F is not even OR the cell in Column C is empty, with a fill color of RGB(255,255,153). I am trying to use the MOD function in the macro to determine if the value in Column F is odd or even. The formula with secondary priority is determined if the value in Column F is even, with a fill color of RGB(255,255,0). In addition to the macro not working, I am not sure if I need to delete the existing conditional formatting. Thank you for your help!Question1.xlsm

Hi Carim, Thanks for your great response. Your answer works perfectly. I appreciate your help and education.

Thank you for looking at my question. I am attaching a small excerpt from a large charity golf tournament that last over 6 rounds. I am trying to use conditional formatting to highlight the lowest 4 rounds for each player. Also, there needs to be a minimum of 4 rounds, so if there are three rounds or less, there should be no highlighting. I have made a number of attempts, including the one on the attached. As you can see, 5 instead of 4 values are highlighted in several rows.

Thank you again for your help

Thank you for the help and the education!

I inserted your code on Sheet4, and it seems to work beautifully. Is that the solution you would recommend?

Thanks you, that is perfect!

However, I have another question. The value in cell J1 is actually controlled by a value on another sheet. I have attached your file, and have added another sheet "Event." When I change the value in J1 on "Event," which is tied to J1 on "Results," it does not seem to activate the code that you added. I apologize, I should have mentioned that in my original post. Still feeling my way. Is there a way to accomplish this?

Thanks again for your assistance.

Thank you for looking at my question. I am attaching an illustration of my problem. Basically I would like to have hyperlinks to one of two hidden sheets based on the value in cell J1. If the value in J1 is either 1 or 3, a link to the hidden sheet "NetSkinsCalc" is inserted in cell J9 with "View Details as the text to display. If the value in J1 is 2, the hyperlink in J9 is replaced by a hyperlink to the hidden sheet "GrossSkinsCalc" again with "View Details as the text to display. Each of those sheets becomes hidden again when exited. As a beginner, I have been unable to come up with a way to do this, particularly with hidden sheets.

Thank you again.

Thanks again.

Fantastic! Works perfectly. Thanks for the code and the education.

Thank you for looking at my question. I am attaching a segment of a spreadsheet where players participating in a large charity tournament are entered. For each foursome, the name of the player is entered into column A and the index of each player is entered into column B. The foursome number is entered into column C. My question relates to the sorting of each foursome as the information is entered. It is helpful if each foursome is sorted by the index of the 4 players, with the lowest index first. Is there a way to sort each foursome automatically as the information is entered? I am a beginner, and I have searched for assistance on this question with no luck. Thanks again.Foursomes.xlsx

Brilliant, and educational! Thank you.

Also, I forgot to add that the Indcalc sheet is hidden. Thanks.

Hi Mumps. I have one more question. How would you clear the values in the Column B on the "IndCalc" page before pasting the values into that column? Otherwise if you change number of flights, it pastes the values below what is already there. I have tried to add that, but I am a beginner and would appreciate your advice on that. Thank you again.

Thank you! Works beautifully.

Thanks for looking at this. I am attaching a spreadsheet to illustrate my question. I am trying to come up with VBA that will copy the list of names in Column B on the "Info" tab to Column B on the "IndCalc" tab. However, I need to insert two blank cells between the Flight numbers on he "IndCalc" page. The Flight number appears in Column A on both sheets. This number can change based on the value in cell F1. There will be at least 150 names on this list of names.

In the illustration there are 4 flights. In the desired results shown on the "IndCalc" page, you will see two blank cells when the Flight number value in Column A changes. It has to be blank cells rather than blank rows because there are formulas in Columns E through Column W. Is there a way to accomplish this?

Thank you again for your help. This is an excerpt of a much larger spreadsheet.

Marked as resolved. Thanks again.

It works perfectly. Thanks for the help and the education!

Thank you for looking at my problem. I am attaching s spreadsheet which is an excerpt from a much larger workbook for a charity golf tournament.

You will see that Players in the tournament are entered into Column B, and their golf index in Column C. Once Players are entered there, they need to be grouped into foursomes by entering their names in Column K, using a drop down list tied to the "Lists" tab. If a Player should cancel, there is a button to delete their name and index from the Workbook. The button will delete the Player from Columns B and C. My problem is how to also delete their name from Column K.

I have assigned each Player a number in case that is useful in solving this problem. I am a beginner, and have spent hours trying to figure this out. Thank you again.