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")
Are the colors set manually or are they the result of conditional formatting?