May 06 2021 12:25 PM
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
May 06 2021 12:43 PM
Are the colors set manually or are they the result of conditional formatting?
May 06 2021 12:47 PM
May 06 2021 01:13 PM
If so you don't need VBA to pick-up colors, logic of conditional formatting could be used in formula.
May 06 2021 01:31 PM
SolutionWhat 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")
May 06 2021 02:08 PM
May 06 2021 02:12 PM
May 06 2021 02:18 PM
May 06 2021 01:31 PM
SolutionWhat 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")