Conditional Formatting Macro

[Allienne]

Hello!

So I have 2 Columns. In Column A there are 3 specific text phrases. In Column B I have a monetary amount. I am trying to fill background or format the cell in B that corresponds with the text in A.

E.g. If Column A says "Example 1", I want Column B to be light green. If Column A says "Example 2", I want Column B to be light yellow.
Formatting.JPG

I want to add this to a macro to run a report that automatically colors the cell in Column B instead of having to manually color it.

Thanks in advance for any help!

[Logit]

.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Allienne]

Logit,

My columns are variable length and so the number of Example 1 and Example 2 do not stay the same across the board. Is there a way to incorporate this into a macro to run that can reference one cell and highlight another?

Thanks!

[Logit]

.

Please Login or Register  to view this content.

I used RGB for the first two because it appears to be the closest match to the colors in your example.

ColorIndex = 0 was used when neither term was present to leave the cell perimeter intact when no color is applied.


I'm certain there are other methods to accomplish the goal, this is just one.

[Allienne]

Logit,

That worked great! Thank you so much!

[Logit]

.
You are welcome !