Forum Discussion
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...
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")
Hi there!
They resolt from condicional formatting
They resolt from condicional formatting
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")
- it doesn't work... 😞
- Sorry! My mistake!!! It works!!! Thank you so much!