Google Sheets conditional formatting text in one cell effects another cell
i'm trying to format a cell so;
IF Cell E3 text contains "Long" I want Cell K3 cell to turn RED when text contains "Bearish"
IF Cell E4 text contains "Long" I want Cell K4 cell to turn GREEN when text contains "Bullish"
IF Cell E5 text contains "Long" I want Cell K5 cell to turn ORANGE when text contains "Indecision"
Solution
red:
=(K3="Bearish")*(E3="Long")
green:
=(K3="Bullish")*(E3="Long")
orange:
=(K3="Indecision")*(E3="Long")
- Condition if-else
- Use of inline if/then/else in Javascript
- Python If Statement definition error
- Else-statement after while-statement, and string comparison with a list of strings?
- If statement with or (||) argument does not work with in_array method
- If loop with two conditions
- Using or in if statement (Python)
- Evaluate boolean environment variable in Python
- Flake8 error: E712 comparison to True should be 'if cond is True:' or 'if cond:'
- IF/OR Formula, Compound to Simplified | I want to simplify, narrow down, and have an evolving cell as information is updated on the Excel sheet
- Excluding Named Worksheets from a Loop
- How to comment an obsolete else-case?
- break out of if and foreach
- Is there a better method than nested if/then to evaluate if cells in one set of columns has data, and then populate a different set of columns
- Using table of same dimensions
- Python Todo List not Adding New Todo in New Row, Rather It Is Appending on the Same Line as Previous Todo
- Array Formula to omit certain values
- Using If statement, to get one String, to pass into API call
- I want to show the available times as bold and unavailable times (strike) in label with corresponding to API data
- How to set "safeAreaInset" under a condition (if clause)
- R If then do - how to create variables based on the condition
- How to sum up checkboxgroupinput objects in R shiny?
- How to check if an object is within an array's objects values?
- Read multiple excel files to dataframes using for loop by reading the month in each filename
- Search a column to find if string is contained in each cell of another column, return third value
- Trying to iterate depending on key input using a while loop with if / else if
- How to prevent blank lines and remove extra spaces in C word-per-line output?
- Shorthand if/else statements : foo?foo:bar vs foo || bar
- If statement based on StartsWith not finding "\\" in C#
- How to check for falsey string value when concatenating?