Help with Conditional formatting Excel

[xaguilar12]

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

[#2 · Accepted solution]

@xaguilar12 

Select the complete range of your data.

Go to Conditional Formatting > Use Formula to determine which cells to format > enter

=AND(A1="apple",E1="")

[#3]

@Roger Govier 

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"?

[#4]

@xaguilar12 

It's practically the same

=($A1="Apple")*($E1<>"Eric")