Aug 13 2021 12:07 PM - edited Aug 13 2021 12:36 PM
Hello, I'm trying to format a cell to show certain text when the two cells on the left have specific text, and anything different than a specific text respectively.
Aug 13 2021 12:28 PM
Aug 13 2021 12:29 PM
In row 3:
=IF(AND(C3,D3<>"COLLECT"),"Good","Bad")
or
=IF(AND(C3,D3<>"COLLECT"),"Good","")
or similar. Fill down.
Aug 13 2021 12:30 PM
Aug 13 2021 12:33 PM
Aug 13 2021 12:38 PM
TRUE and FALSE are boolean values, not text strings.