Forum Discussion
Solved
How do I create a formula that will change the text color if 2 words exist in two different cells?
Hi, I want to create a spreadsheet that will change the font color when a combination of words (in 2 different cells) exists. How would I do that? As an example, it would be on the same row but i...
- You can use conditional formatting. Select custom formula and then the formula would be like:
=($A1="Blue")*($H1="Rabbit")
notice the $ in front of the A and H "locking" those columns so you can apply it to many cells on the row and they will all reference those columns and multiple rows will all look at their row (i.e. no $ before the row number)
and under format just go to font tab and change how you want it to look
