create conditional formatting in another column based on the data/valuess in another

**deed23** · 09-24-2021, 10:51 AM

I'm creating a participation sheet for a game. In the sheet, I'd like a column for inputing data as it appears in the game which is related to how many attempts a participant has made. There are 10 attempts. When the first attempt has been taken it's indicated in the game as 0/1. It will stay as 0/1 if the attempt has failed. If it has been completed, then it is then change to 1/1. The same goes for when the 2nd attempt is taken, it will appear as 0/2 or 1/2 (where the number after the "/" is the current attempt).

I'd like to create conditional formatting in another column based on the data/valuess in the "attempts" column; where the text and cell is red if the participants have made less than 10 attempts. How would I go about doing this?

**AliGW** · 09-24-2021, 10:53 AM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

create conditional formatting in another column based on the data/valuess in another

LinkBack

Thread Tools

Rate This Thread

Display

create conditional formatting in another column based on the data/valuess in another

Re: create conditional formatting in another column based on the data/valuess in another

Thread Information

Users Browsing this Thread

Similar Threads

Macro for seaching a phrase and add 7 rows after that phrase

[SOLVED] Search column of cells for a phrase, then change a cell to match a parallel cell to phrase

Get rid of a phrase in the text

Not sure how to phrase the question - 'sort to show cheapest price of parts?'

Function to return text from phrase X to phrase Y

[SOLVED] Delete a row with a certain phrase?

Phrase Permutations

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions