Cell color and text box

[mma3824]

Hello -

I have 2 questions, both dealing with automating tasks. The first is that I would like to have a macro that would run that would change the color in cells that would have the word FALSE in it. I have 3 columns J, N and T that are checking columns and would either read TRUE or FALSE. If the color could be red that would even be better.

The second question has to do with having a pop up text box to appear asking for a company name to be typed into it. This name would then populate cells with item numbers in it. An example is below:
Before After
123 Smith 123
156 Smith 156
175 Smith 175
156 Smith 156

Thanks for all your help in advance!

[Special-K]

You dont need a macro you need Conditional Formatting.
Use the option that says "Use a formula to..."
Select J1
Enter this formula as a Conditional Format
=(J1="FALSE")
Format as red
Now use Format Painter to copy the format to the other cells

[Jakobshavn]

And here is the code to preface data with a user-supplied company name:

Please Login or Register  to view this content.

[Jakobshavn]

And here is the code to preface data with a user-supplied company name:

Please Login or Register  to view this content.