Forum Discussion

aigr_pt's avatar
aigr_pt
Copper Contributor
May 06, 2021
Solved

how to create a function that uses two colour criteria to generate text

Hi!

 

I need help creating a function that returns text by giving a combination of two colors.

 

For example, if I pick two cells, one red and one green, I want to get BAD. If both cells are green, then I want to get GOOD.

 

Can anyone help?

 

Thanks

 

excel
Formulas and Functions
Macros and VBA
  • HansVogelaar's avatar
    HansVogelaar
    May 06, 2021

    aigr_pt

    What Sergei writes...

    Let's say a cell is green if the value is >=5 and red if it is <5

    You can use the formula

     

    =IF(AND(cell1>=5, cell2>=5), "GOOD", "BAD")

7 Replies

    • aigr_pt's avatar
      aigr_pt
      Copper Contributor
      May 06, 2021
      Hi there!
      They resolt from condicional formatting
      • HansVogelaar's avatar
        HansVogelaar
        MVP
        May 06, 2021

        aigr_pt

        What Sergei writes...

        Let's say a cell is green if the value is >=5 and red if it is <5

        You can use the formula

         

        =IF(AND(cell1>=5, cell2>=5), "GOOD", "BAD")

Resources