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'...
Formulas and Functions
Harun24HR's avatar
Harun24HR
Bronze Contributor
Nov 08, 2022
Function can only return values not format. You can return color by function. You need vba coding.
  • Hills998's avatar
    Hills998
    Copper Contributor
    Nov 10, 2022

     OK.

    Thanks for the information.

     Harun24HR 

Resources