Lookup Functions to bring Font and textColor

[Naveed1002]

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

[#2]

@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.