Forum Discussion

Hills998's avatar
Hills998
Copper Contributor
Nov 08, 2022

index and match formula to return the text and colour of the cell

I am trying to have the formula return the colour of the cell as well as the text contained in the cell in my Index Match Formula.

This is the formula: - =IF(OR($S9="",$R9=""),"",INDEX('Risk Matrix'!$B$5:$F$9,MATCH($R9,'Risk Matrix'!$A$5:$A$9,0),VALUE(LEFT($S9,1))))

 

 Does anyone have any ideas please ?

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Function can only return values not format. You can return color by function. You need vba coding.

Resources