Conditional Formatting in Google Sheets with another table INDIRECT
I want to highlight names in A7:A in color on the target sheet if a checkbox is marked in the source table “Data” (TRUE):
conditional formatting on a single cell where criteria is another column [solved]
Cell A1 contains the text "FLAG".
Column B contains dates.
I want to apply conditional formatting to cell A1 if any date in column B is less than 2 days from today(), and if the date is past today().
conditional formatting on a single cell where criteria is another column [solved]
Cell A1 contains the text "FLAG".
Column B contains dates.
I want to apply conditional formatting to cell A1 if any date in column B is less than 2 days from today(), and if the date is past today().
Is there a way to reference a cell as the midpoint when conditionally formatting?
I am trying to conditionally format cells so that they are shaded in green if they are higher than the value of D6 (the topmost cell pictured) and red if they are lower. In order to do this, the midpoint in my color scale seems like it should be D6, but this does not register as an appropriate value when I try it.
Conditionally format the last occurrence of a word from a column list of words
How do you conditionally format the last occurrence of a word from a column list of words in Google Sheet?
Conditional formatting comparing cell to cell values in a range
Each column is a number of requests by month, so I would like to mark the values that 15% bigger, then in a previous month. (rows are “query name” and not important)
Google Sheet Sequential Conditional formatting fails
how can i compare text from column a in column b in google sheet?
I need to check if any text from column A appears in any cell on column B (partial or exact).
and if possible- mark the cells in some way.
for example in the screen shot- items in column A have a match (or partial match) on column B.
How do I use contents of one cell to modify the conditional formatting of another cell?
I have a table of cells filled with either Y or N. I want the contents of the Y/N table to determine which columns are included in a subsequent content matching check. The desired rule would produce the following behaviors:
If A1, B1, and C1 all contain Y, I want $E5 to display whether the contents of $A5, $B5, and $C5 all match.
If A2 and B2 contain Y but C2 contains N, I want $F5 to display whether the contents of $A5 and $B5 match.
If A3 and C3 contain Y but B3 contains N, I want $G5 to display whether the contents of $A5 and $C5 match.DESIRED OUTPUTS