Macro for coloring cells based on contents

**serge_kashlik** · 12-31-2017, 10:17 AM

I have the following macro

Formula:

Please Login or Register  to view this content.

End Sub

I have problems with this line

Formula:

Please Login or Register  to view this content.

Basically I want all the cells with constants have one font color, those that perform a calculation to have another and those that derive their value from another sheet a third. However, the above mentioned line does not seem to recognize the multiplication symbol * for some reason and colors the cells that use values from other sheets and multiply them as if they are simply derived from another sheet (i.e. vbRed instead of black).

I am still quite new to VBA so if anyone could help I would appreciate it.
Thx in advance

**jindon** · 12-31-2017, 10:29 AM

Not tested

Please Login or Register  to view this content.

**davesexcel** · 12-31-2017, 10:48 AM

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.

To add a file to a post

**serge_kashlik** · 12-31-2017, 11:37 AM

Thank for the tip
All done

**jindon** · 12-31-2017, 07:43 PM

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

**serge_kashlik** · 12-31-2017, 07:54 PM

Did not solve it unfortunately

**jindon** · 12-31-2017, 07:56 PM

Then you will need to upload a workbook with before/after.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**serge_kashlik** · 12-31-2017, 08:18 PM

I edited the original thread and added the file

**jindon** · 12-31-2017, 08:34 PM

Your problem cell are now red.
What color should they be?

**jindon** · 12-31-2017, 08:42 PM

And what do you expect to match with "*~**" ?

Do you mean escape asterisk like "*[*]*" ?

**serge_kashlik** · 12-31-2017, 09:25 PM

I want any cell that contains a formula which uses the multiplication sign to have the font color black. The problem now is that the macro does not recognize the * as a separate symbol and I thought that usually in order to distinguish a wildcard character you need to use the "~".
I tried several ways including[*], /* and ~* but none of them seem to work

**jindon** · 12-31-2017, 09:35 PM

It should work

Please Login or Register  to view this content.

If you haven't got what you want, it would be the way you use it.

And do not recommend to use same procedure name of Module name.

See the attached

**serge_kashlik** · 12-31-2017, 09:38 PM

Thx for the help, it works as I need it to

Macro for coloring cells based on contents

LinkBack

Thread Tools

Rate This Thread

Display

Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Re: Macro for coloring cells based on contents

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Color cells based on start and end dates and continue coloring based cycle days On & Off

[SOLVED] I need a macro to clear cells based on contents

[SOLVED] Combining Contents of two cells whilst preserving text coloring

[SOLVED] Coloring cells based on value in another cell

Coloring Cells dependent upon their contents

Macro to hide columns based on contents of two cells

[SOLVED] Coloring Cell Font based on Cell Contents

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions