google-sheetsgoogle-sheets-formulags-conditional-formattinggs-vlookup
Conditional formatting with data validation + named range from other sheet in google sheets
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
Solution
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"
- Google Sheets: Sumif formula
- Randomize cells in Google Sheets
- Model / Year formula fails when a sequence starts stops then starts again
- Google script for move rows depending on checkbox - Google sheet
- Getting a “Google hasn’t verified this app” warning when creating a trigger - ok to ignore it?
- Count in specific ways in Google sheets
- Fixing 1 row, and leaves each following row movable
- How to pass a range as a function parameter?
- Auto pulling a value in a formula to the next value in Google Sheets
- How to Extend a Formula to Apply to All Rows Using MAP or ARRAYFORMULA?
- Google Sheet - copy range if match
- shortest formula to get the last non zero value from column
- Copying data from a sheet to another with conditions
- How can I automatically generate due dates in Google Sheets based on payment plans?
- If one cell IS NOT EMPTY put text on another cell in Google Sheets
- How can I create a simple duplicate detector?
- Authorization is revoked every week. How to maintain persistent authorization?
- Conditional borders in Google Sheets
- Automatically adding a row to a sheet with data from another sheet once every day
- Adding borders based on grouped rows and conditional formatting in Google Sheets
- Illegal Argument Error Thrown When Trying to setTextStyle() for Rich Text in Google Apps Script
- Passing variables to time based triggers
- Google Apps script to conditional format cell border
- Multiple dropdown questions on a google-form tied to spreadsheet
- Google Apps Script sort stopped working "Exception: This operation is not supported on a table header row."
- count number of cells with precise number of repeated characters
- How can I extract columns based on multiple column value/criteria?
- How to count distinct column values in Google Sheets?
- Pivot table (calculated field)
- How do I get Google Script to read the display value of a sheet's cell? It keeps returning some random date instead