Converting Index Match to VBA Code

[Geni O]

I have the following formula in several cells in column C from row 8 to row 61:

=IFERROR(INDEX(Comments!$K$2:$K$76,MATCH(C22,Comments!$B$2:$B$76,0)),"COMMENT REQUIRED")

Since it is an index match, only values are copied. I would like to implement VBA code that will preserve this index match, but also keep the source formatting of what is being copied.

 

[Norie]

What formatting is it you want preserved?

 

[Geni O]

I would like to preserve the color and bold styling. Or ideally, the code wouldn't need to preserve the style, but will simply apply the style based on the index matched value. For example, if the value that is index matched from another sheet is equal to "Hello" I would like it to be bold and red. Otherwise it would just be normal.