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

New Contributor

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 ?

2 Replies
Function can only return values not format. You can return color by function. You need vba coding.


Thanks for the information.