Macro Code To Paint The Cells Depended on Results

[grubenyan]

Hi everyone,

I need a macro code that will paint the cells as follow: if it sees "normal" in the cell - paint it green, "issue" - paint it red, "info" - paint it blue. Thanks in advance!!

[6StringJazzer]

Why do you want to use VBA for this? I would recommend conditional formatting. See image and attached file.

Capture.JPG

[grubenyan]

I need to automatically have these colors whenever I my function returns these words (info, normal, issue)

[carlmon]

6stringjazzers suggestion will accomplish exactly that.

[grubenyan]

Thank you, guys

[6StringJazzer]

If you attach your file, I can update your actual file to show you how it works. See yellow banner at the top of the page.

[grubenyan]

Thank you so much. I did that yesterday according to your attachments.

[6StringJazzer]

There is no file attached to any of your posts in this thread.

The paper clip icon does not work for attachments. To attach a file:

1. Under the text box where you type your reply click the Go Advanced button.
2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
3. Click the Choose File button to select a file to attached.
4. Click the Upload button to upload the file.
5. Then click the Close This Window button. Your file is now attached to your post.