Forum Discussion

xaguilar12's avatar
xaguilar12
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's avatar
    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="")

xaguilar12's avatar
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's avatar
SergeiBaklan
Diamond Contributor
Jul 16, 2019

xaguilar12 

It's practically the same

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

Resources