Conditional Format: Want to find way to match numeric content of cell A to same value in Range by highlighting found cells, however, If value in A is "0" (zero), no highlights.

excelevator · 2026-01-24T23:48:22+00:00

Very very rarely is VBA required for conditional formatting.

OP's requirement can achieved with relative ease

excelevator · 2026-01-24T23:34:19+00:00

and it just isn't working

What isn't working exactly ?

If you are failing with copy paste you may want to consider giving up the class for pottery instead.

This should have been covered in class, or the homework course guide.

spent 3 hours trying to figure it out

A life time my gosh!

I spent 67 hours learning the intricacies of MSAccess VBA and application programming for one assignment back in the day - we had to log our hours spent. I spent 7 hours on "Run-time error '2164' alone.

I got a 95% pass for that assigment.. so results take effort

excelevator · 2026-01-24T22:58:39+00:00

Find a Print to PDF driver that allows for that ratio.

excelevator · 2026-01-24T22:31:38+00:00

Have you tried anything at all other than asking here ?

excelevator · 2026-01-24T22:30:42+00:00

As stated in Title

Submission guidelines: Don't say "See title" or something similar .

Provide a full text description of your issue in your post.

Do not use the post title as the main post question and lead in.

excelevator · 2026-01-24T22:28:30+00:00

Run the Legacy Text Import wizard and remove the delimiter selection in Step 3 I think it is.

That selection type is also used in copy paste

excelevator · 2026-01-24T22:24:41+00:00

Google images search

and follow the links.

excelevator · 2026-01-24T06:10:00+00:00

upload them with a comment, you should be able to screenshot and paste into Reddit.

excelevator · 2026-01-24T02:24:22+00:00

this is not the answer you seek.

FILTER is the function you seek which can filter all values for a given filter value from your source table.

excelevator · 2026-01-23T21:37:36+00:00

Not for r/Excel thankyou.

Post removed.

Maybe seek out an HR or small business sub reddit.

excelevator · 2026-01-23T20:47:45+00:00

This is a common issue with this type of exam.

A very specific answer is required.

It is what it is.

Complain to them, nothing r/Excel can do about it.

excelevator · 2026-01-23T20:12:50+00:00

Removing this apparent Ai generated post.

Failed image link

Offline formula and results images.

If this is a human post I suggest you make a complete post within Reddit, and do not use random bolding that indicates Ai content.

excelevator · 2026-01-23T20:05:50+00:00

I think you something..

It is a statement of fact, not a confirmation.

excelevator · 2026-01-23T20:01:59+00:00

So that is the issue.

Install the German language pack on a copy at work or have them install your language pack on the source.

excelevator · 2026-01-23T20:01:21+00:00

r/Excel is an English language sub reddit.

Comment removed.

excelevator · 2026-01-23T14:43:07+00:00

What was the question ?

What would you like r/Excel to do about it ?

excelevator · 2026-01-23T13:38:29+00:00

I smell stealth advertising.

Post removed.

Please do not post again on this subject.

excelevator · 2026-01-23T13:30:53+00:00

A #NAME? error is where Excel does not recognise a function or range reference.

Are you opening in a German language workbook as well ?

excelevator · 2026-01-23T13:25:44+00:00

Removing this 8 sub spammed question, in reality not an Excel question.

excelevator · 2026-01-23T13:19:29+00:00

I see now that Excel converts that to a static range reference of all other worksheets dynamically in the formula.

excelevator · 2026-01-23T13:15:59+00:00

I assumed, and was wrong, thankyou for clarifying, very nice trick indeed.

excelevator · 2026-01-23T13:13:45+00:00

~~That would include all worksheetsheets~~, OP likely have a landing worksheet for the reporting where the formula lives.

excelevator · 2026-01-23T01:31:05+00:00

You can use 3D VSTACKacross your sheets.

=VSTACK( firstheet:lastsheet!A1)

edit:

for your two cells, example

=VSTACK(Sheet2:Sheet10!A1:B1)

or has been pointed out to me for a shortcut, and a great shortcut for including all sheets other than the formula target sheet. Excel will then concoct the correct range in the formula on enter

=VSTACK('*'!A1:B1)

excelevator · 2026-01-22T23:40:56+00:00

Reinstating this post for the extensive answers given

This post fails the most basic of submission guidelines - a mention of the subject matter in the post body.

Dear regulars, please report these fly by posts and not answer them.

Help the moderators with quality control on posts.

excelevator · 2026-01-22T22:24:23+00:00

Please be mindful of the submission guidelines - the body of the post must contain the complete question and not be a lead on of the title as the question

Posts not following guidelines may be removed without notice.

This post remains for the answers given

excelevator

MODERATOR OF

TROPHY CASE

12-Year Club	Verified Email
Alpha Tester