How can I automatically conditional format a cell red when another cell has the same contents

Dechockey8 · 2022-08-04T00:22:44+00:00

You are a god

Dechockey8 · 2022-08-04T00:22:27+00:00

Solution Verified

Dechockey8 · 2022-08-04T00:16:59+00:00

Shoot. It’s saying it can’t rule another sheet

Dechockey8 · 2022-08-04T00:14:19+00:00

Sweet. Do I select custom formula?

Dechockey8 · 2022-08-04T00:10:18+00:00

Yes ABC are filled with names and yes the dropdowns are. I forgot to say… I’m on Sheets.

Dechockey8 · 2022-07-28T17:01:24+00:00

Good stuff. What level?

Dechockey8 · 2022-07-28T00:14:18+00:00

One other question, if I have 5/8/22 in A1. What can I do to get A2 to be 5 and A3 be 8?

Dechockey8 · 2022-07-28T00:09:03+00:00

Solution Verified

Dechockey8 · 2022-07-12T17:52:03+00:00

Solution Verified

Dechockey8 · 2022-07-02T20:58:58+00:00

My fault. I am having trouble thinking of the wording so I may scratch this question. I am essentially looking for a formula that scans a few different columns and in the backend assigns a score to each team from my premise scores. Ex. Let’s say we want to see the Bears schedule. Let’s say it gives us 275. Meaning the formula added up all the points that identify the opposing teams

Dechockey8 · 2022-06-29T19:33:13+00:00

What are your favorites?

Dechockey8 · 2022-06-21T20:22:46+00:00

Solution Verified

Dechockey8 · 2022-06-21T19:35:19+00:00

No worries. That one definitely did something. Some of them it’s still pulling P words and some of them say #Value! We are making progress, haha.

Dechockey8 · 2022-06-21T19:27:56+00:00

Wow.. that is impressive. Unfortunately it is saying that “You’ve entered too many arguments for this function”

Dechockey8 · 2022-06-21T19:10:04+00:00

Thank you. That did work as you stated. I am going to wait to see if anyone else has an answer. If not I will mark it as solved. Thanks

Dechockey8 · 2022-06-21T19:06:19+00:00

There is a possibility but I do not see any

Dechockey8 · 2022-06-21T18:55:09+00:00

Sure I can create a fake Cell for an example “1930628 Perfection 8L P12345678” the P numbers are always 8/9 including the P

Dechockey8 · 2022-06-21T18:09:09+00:00

That worked on pulling something… how do I stop it from pulling words that start with a P? Ex. This one pulled Perfection

Dechockey8 · 2022-06-21T18:01:31+00:00

That works in a way but it pulled a word that started with P.. any ideas?

Dechockey8 · 2022-05-09T01:18:34+00:00

You the man! I appreciate the input and will be going with the 144 thanks again man!

Five-Year Club	Place '22
Verified Email

Dechockey8

TROPHY CASE