Forum Discussion

Copper Contributor

Jul 16, 2019

Solved

Help with Conditional formatting Excel

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 examp...

excel

Formulas and Functions

Roger Govier
Jul 16, 2019
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="")

Roger Govier

Brass Contributor

Jul 16, 2019

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="")

xaguilar12
Copper Contributor
Jul 16, 2019
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"?
- SergeiBaklan
  Diamond Contributor
  Jul 16, 2019
  xaguilar12
  
  It's practically the same
  
  =($A1="Apple")*($E1<>"Eric")