Forum Discussion

Naveed1002's avatar
Naveed1002
Copper Contributor
Mar 15, 2021

Lookup Functions to bring Font and textColor

Hello,

 

While I am using Vlookup or Index match. I am only getting corresponding lookup values not their font color or text format is there any possibility that we could able to get those things to. I know we could use VBA but need know if there is any formula or any other method to do it without VBA.

 

Thanks.

NA

excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 15, 2021

    Naveed1002 

    No, formulas work with cell values, not with cell properties like color. To work with properties you need VBA, your own or already built functions.

Resources