Forum Discussion

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

excel

Formulas and Functions

Macros and VBA

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")

HansVogelaar

MVP

May 06, 2021

aigr_pt

Are the colors set manually or are they the result of conditional formatting?

aigr_pt

Copper Contributor

May 06, 2021

Hi there!
They resolt from condicional formatting

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")
- aigr_pt
  Copper Contributor
  May 06, 2021
  it doesn't work... 😞
  - HansVogelaar
    MVP
    May 06, 2021
    aigr_pt
    
    1) What are the conditional formatting rules?
    
    2) Which cells do you want to look at?
SergeiBaklan
Diamond Contributor
May 06, 2021
aigr_pt

If so you don't need VBA to pick-up colors, logic of conditional formatting could be used in formula.