Conditionally color highlight value in Column B based on adjacent Column A value in google spreadsheet

0
votes

Environment: Google Spreadsheet.

What I want to do:

Whenever there is Value a in column2 corresponding to aValue 1 in column1. I want Value a cell to be higlighted in a particular color. 

Col1    Col2
aValue 1    Value a
aValue 2    Value b
aValue 1    Value a
aValue 1    Value c

enter image description here

What custom formula do I use here?

enter image description here

I saw this similar Q Excel Conditional Formatting If Column A Contains ANY Value Highlight Adjacent Cell In Column B But this is not what I'm looking for.

I'm very new to spreadsheet and excel. Appreciate any pointers.

Update :
There are two sets:
Case 1: Column A has entry X and corresponding Column B has value of 0 Color 1 highlight

Case2 Column A has entry Y and Column B has non zero value. Color2 higlight

1
google-sheetsgs-conditional-formatting
Which conditional formatting formulas did you try? How many conditions are there? Do you know them ahead of time? You need to supply more information. – tehhowch
sorry I forgot to add the formulas which I tried. Yest I know the condition ahead of time. There are two sets: Case 1: Column A has entry X and corresponding Column B has value of 0 Case2 Column A has entry Y and Column B has non zero value. – kRazzy R

1 Answers

1
votes

Please select ColumnB, clear any CF rules from it and: Format - Conditional formatting..., Custom formula is and: 

=and(A1="aValue 1",B1="Value a")

with highlighting of your choice and Done.