Conditional formatting with data validation + named range from other sheet in google sheets

Question

I'm really struggling with getting my conditional formatting to work. I've seen a couple of posts online plus here around using INDIRECT to reference the desired cell in a different sheet for a custom formula in my conditional format rule, but it's not working. Wondering if someone can review the sheet and see what I am doing wrong.

In my sheet, you will see exactly what I've coded and I've annotated the desired behavior. https://docs.google.com/spreadsheets/d/1keGEuaxhjoXJl9TrKWgkAyh4ut22pMmfnTsDranksY0/edit#gid=0

player0 · Accepted Answer · 2020-05-06 21:11:52Z

1

you miss equal sign and double quotes.

blue formula:

=VLOOKUP($A2,{INDIRECT("WarLinesValuesTypes")},2,0)="Defense"

red formula:

=VLOOKUP($A2,{INDIRECT("WarLinesValuesTypes")},2,0)="Offense"

answered May 6, 2020 at 21:11

player0

131k14 gold badges91 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional formatting with data validation + named range from other sheet in google sheets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related