Jul 16 2019 10:13 AM
I am trying to create a Colored Matrix to show errors in my data. I want to be able to see all of the cells that are blank in one column only if there is a specific value in another column. For example, I have column A with multiple fruit, and another column E with a person's name. I want to highlight red every blank cell in column E that is in the same row as "apple" in column A. I would also like to do this to show countifs throughout the whole spreadsheet, but I cant find what I am doing it wrong. Thanks
Jul 16 2019 10:21 AM
SolutionSelect the complete range of your data.
Go to Conditional Formatting > Use Formula to determine which cells to format > enter
=AND(A1="apple",E1="")
Jul 16 2019 10:46 AM
Thanks so much! Do you know what to do if I want to highlight every Apple cell in Column A that contains every value except for a specific name in column E- such as "Eric"?
Jul 16 2019 02:07 PM
Jul 16 2019 10:21 AM
SolutionSelect the complete range of your data.
Go to Conditional Formatting > Use Formula to determine which cells to format > enter
=AND(A1="apple",E1="")