How many columns have red text in them?

**Sybille** · 01-04-2023, 05:13 PM

Hello Forum,

I need a code to write in column G the number of columns that contain red text for each row of my table.

Please see the attached file with an example.

Thank you very much in advance.

S.

**WideBoyDixon** · 01-04-2023, 06:41 PM

Try this:

Please Login or Register  to view this content.

WBD

**6StringJazzer** · 01-04-2023, 06:47 PM

I installed this code into your file:

Please Login or Register  to view this content.

**Sybille** · 01-05-2023, 04:15 PM

Thank you WideBoyDixon and 6StringJazzer, both your solutions work perfectly! Game changer for a very long table...

Have both a very nice day and a healthy and happy year 2023.

S

How many columns have red text in them?

LinkBack

Thread Tools

Rate This Thread

Display

How many columns have red text in them?

Re: How many columns have red text in them?

Re: How many columns have red text in them?

Re: How many columns have red text in them?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Getting text to columns to correctly separate address data within single cell into columns

Split text into columns - formula only, no vba or excel Text to Columns

Split text into columns - formula only, no vba or excel Text to Columns

pull text from 2 columns based on finding text in other columns

Subtotaling columns of numbers using autofiltered text evaluations in adjacent columns

MAcro to - copy, transpose, text to columns, remove column A, combine all columns in 1

Linking text columns with text and data columns

Bookmarks

Bookmarks

Posting Permissions