Jun 01 2023 08:09 AM
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 in different columns, I would want the font to turn red when say Blue (in A1) is entered and Rabbit (is entered in H1).
Is there a way to do this?
Thank you,
Jun 01 2023 08:39 AM
SolutionJun 01 2023 08:52 AM
Thank you very much. I will give this a try. If I want it to apply to the whole spreadsheet for columns A & H, would I just leave off the cell # =($A="Blue")*($H="Rabbit")?
Jun 01 2023 09:20 AM
Jun 01 2023 10:10 AM
@mtarler Awesome! Thanks very much for your knowledge & your time!! It's very much appreciated. :)
Jun 01 2023 08:39 AM
Solution