About 1,043,585 results (4,035 milliseconds)
Google Sheets IF Statement with Numbers and Text - Google Docs ...
https://support.google.com/docs/thread/120398679/google-sheets-if-statement-with-numbers-and-text?hl=en Aug 8, 2021 ... I'm looking through cells L5 through L9, and if the sum of those cells is equal to 0 AND one (or more) of the cells contains the letter T, then put the letter ...
Use conditional formatting rules in Google Sheets - Computer ...
https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a ...
Conditional IF statement not working - Google Docs Editors ...
https://support.google.com/docs/thread/59831408/conditional-if-statement-not-working?hl=en Jul 19, 2020 ... I am trying to apply custom formula conditional formatting to the address column to turn the background red and the text white if the “Do Again” column ...
Conditional formatting: remove cell highlight if cell in next column ...
https://support.google.com/docs/thread/33397994/conditional-formatting-remove-cell-highlight-if-cell-in-next-column-contains-text?hl=en Mar 13, 2020 ... When column D has text/dates in it, I'd like column C's formatting to be blank. So, if something was due yesterday, but the work was submitted ...
Conditional Formatting: If one cell contains exact text, another one ...
https://support.google.com/docs/thread/128805695/conditional-formatting-if-one-cell-contains-exact-text-another-one-will-say-yes?hl=en Oct 1, 2021 ... I am trying hard to figure out how to do conditional formatting for again. I have a form that students can write in what things they want ...
Conditional formatting if isblank add text to cell - Google Docs ...
https://support.google.com/docs/thread/5396425/conditional-formatting-if-isblank-add-text-to-cell?hl=en May 3, 2019 ... I would like to create a custom formula to add the text to a blank cell. In the example, I would like cell E3 to say "Enter Name" until I click ...
How to autofill text in the cell based on the exact text in another cell ...
https://support.google.com/docs/thread/157667730/how-to-autofill-text-in-the-cell-based-on-the-exact-text-in-another-cell?hl=en Mar 28, 2022 ... I am struggling to make my formula work. The idea to set a conditional formatting for column C when if Orderer is James (text in $B2 = "James") ...
Conditional formatting if another sheet contains specific text ...
https://support.google.com/docs/thread/2709736/conditional-formatting-if-another-sheet-contains-specific-text?hl=en Mar 20, 2019 ... ... write the Countifs function and the conditional formatting . I recommend you to use Array formula in the helper it's much better - check ...
Apply two conditional formatting rules simultaneously in Google ...
https://support.google.com/docs/thread/13813522/apply-two-conditional-formatting-rules-simultaneously-in-google-sheets?hl=en Sep 7, 2019 ... For example, if the course is CHEM 212, I want columns C and D to have a light green fill colour. If the text in column D contains "quiz," then ...
How can I search in a cell for a word in a sentence, and if it find it ...
https://support.google.com/docs/thread/147050478/how-can-i-search-in-a-cell-for-a-word-in-a-sentence-and-if-it-find-it-then-write-a-certain-word?hl=en Jan 21, 2022 ... How can I search in a cell for a word in a sentence, and if it find it, then write a certain word ... text, if not found it will return ERROR.
Cell formula to display different text based off text in another cell ...
https://support.google.com/docs/thread/158958439/cell-formula-to-display-different-text-based-off-text-in-another-cell?hl=en Apr 7, 2022 ... E.g. if cell D2 contains /02/ then show Ball, but if it contains /03/ show Sock. Aim of this is I can write the formula once, apply it to ...
How to hide the contents in a cell if it meets a certain condition ...
https://support.google.com/docs/thread/185741957/how-to-hide-the-contents-in-a-cell-if-it-meets-a-certain-condition?hl=en Oct 25, 2022 ... I know I could do this with conditional formatting and just turn the text white if it contains "1/30/2060" but the data is part of a larger ...
Google Sheets Conditional Formatting for Text - Google Docs ...
https://support.google.com/docs/thread/54845341/google-sheets-conditional-formatting-for-text?hl=en Jun 22, 2020 ... You haven't given us a the whole story. If you must keep them as text, try using a VALUE function in a Custom Formula is type conditional format ...
SHEETS IF Function - change text in cell depending on the data in ...
https://support.google.com/docs/thread/18478561/sheets-if-function-change-text-in-cell-depending-on-the-data-in-two-other-cells?hl=en Nov 3, 2019 ... If it's not NEW, then check for the following: if U is less than today (shouldn't it be greater than today..?), return OVERDUE, otherwise check ...
Changing Text Color with Multiple Conditional Formatiing - Google ...
https://support.google.com/docs/thread/151670324/changing-text-color-with-multiple-conditional-formatiing?hl=en Feb 21, 2022 ... if you drag rule 3 to the top, the text should change to red for ... I figured I would have to write more Conditional Formatting rules ...
How do use a checkbox to return text into another cell using "IF ...
https://support.google.com/docs/thread/99424400/how-do-use-a-checkbox-to-return-text-into-another-cell-using-if?hl=en Feb 23, 2021 ... ... text in one cell based on which of five checkboxes is ticked. I thought I could solve this with Conditional Formatting, but when I enter the =if ...
Formula to return if cell is blank (no visible text) vs contains formula ...
https://support.google.com/docs/thread/168620875/formula-to-return-if-cell-is-blank-no-visible-text-vs-contains-formula-value?hl=en Jun 24, 2022 ... I am trying to use a simple function to return one value if true and another if false. I have a few columns, all containing a formula.
How to do this: If a condition is true, add text to a cell. - Google Docs ...
https://support.google.com/docs/thread/139520255/how-to-do-this-if-a-condition-is-true-add-text-to-a-cell?hl=en Dec 9, 2021 ... ... then editing the text normally. It shouldn't be any harder copying the dragdown formula to a new sheet. Just be sure to put it on row 3, or ...
How do I use the trim formula uniquely within conditional formatting ...
https://support.google.com/docs/thread/68379310/how-do-i-use-the-trim-formula-uniquely-within-conditional-formatting?hl=en Sep 1, 2020 ... Conditional formatting custom formulas behave like dragdown formulas. So you write the formula as if it were in the top left cell, and you were going to drag ...
Conditional Formatting: Getting "If cell is bold, change formatting" to ...
https://support.google.com/docs/thread/60892094/conditional-formatting-getting-if-cell-is-bold-change-formatting-to-work?hl=en Jul 24, 2020 ... Conditional Formatting can't tell if a cell is bold or not. CF rules are based on the value in the cell, like text or numbers or dates or checkboxes.