About 1,547,273 results (1,792 milliseconds)
How do I change font color by a formula? - Google Docs Editors ...
https://support.google.com/docs/thread/38107743/how-do-i-change-font-color-by-a-formula?hl=en Apr 5, 2020 ... First select the cell, range, row or column to want to set background color on and then click the new item in the menu and after you click "OK" ...
Text appears white regardless of how the cell is formatted. Cannot ...
https://support.google.com/docs/thread/22552843/text-appears-white-regardless-of-how-the-cell-is-formatted-cannot-change-default-text-color?hl=en Dec 11, 2019 ... Cannot change default text color. The formula bar appears with white text over a black background, resulting in white text in whichever cell ...
Formula to change text color for row based on contents on one cell ...
https://support.google.com/docs/thread/244247692/formula-to-change-text-color-for-row-based-on-contents-on-one-cell?hl=en Nov 16, 2023 ... We have a running list of large donors on a Google Sheet. Occasionally, we get donations for a specific program and we like to change that text color to red.
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 ...
How can I format cells to change color based on date in cell and ...
https://support.google.com/docs/thread/228833054/how-can-i-format-cells-to-change-color-based-on-date-in-cell-and-current-date?hl=en Aug 4, 2023 ... I saw a post from 3 years ago that had formulas for exact dates, i.e. green if it is today's date, red if not, however my needs are much more ...
Looking for a formula to change the color in only one string within a ...
https://support.google.com/docs/thread/210277055/looking-for-a-formula-to-change-the-color-in-only-one-string-within-a-cell?hl=en Apr 9, 2023 ... I am aware of conditional formatting, which I am used to changing the font and color of the entire cell rather than a portion. My intent is to ...
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 ... ... spreadsheet which contains a negative number: Format cells if less than 0. The problem is with formula number (3). It works fine for any cell ...
Change colour In one cell depending on input in other cell - Google ...
https://support.google.com/docs/thread/62000896/change-colour-in-one-cell-depending-on-input-in-other-cell?hl=en Jul 30, 2020 ... Instead I'll just show the method I would use which uses a "Custom Formula" in the conditional formatting. ... Adjust the text and the color above ...
If cell (C3) is greater than cell (B3) colour text green, if C3 is less ...
https://support.google.com/docs/thread/121896053/if-cell-c3-is-greater-than-cell-b3-colour-text-green-if-c3-is-less-than-b3-colour-text-red?hl=en Aug 18, 2021 ... ... formulas that will change the text colour if greater than, or less than. I just can't find a formula and lack the knowledge of how to string ...
Can I automatically copy the cell color that has been set elsewhere ...
https://support.google.com/docs/thread/59760218/can-i-automatically-copy-the-cell-color-that-has-been-set-elsewhere-in-the-spreadsheet?hl=en Jul 18, 2020 ... I've tried conditional formatting but can't find a rule that let's me check text input (IF name exist in colomn A, change background color to ...
How can I format text to be a different color if that text does not ...
https://support.google.com/docs/thread/75260108/how-can-i-format-text-to-be-a-different-color-if-that-text-does-not-appear-in-a-list?hl=en Oct 6, 2020 ... I am trying to format text to change color if that text does not appear in a list. I know how to do conditional formatting for if the text was in the list.
How can I change the color of certain words in a cell throughout a ...
https://support.google.com/docs/thread/104468823/how-can-i-change-the-color-of-certain-words-in-a-cell-throughout-a-sheet?hl=en Mar 30, 2021 ... ... color. I have been doing the words one at a time to be my desired color, but I would like to find a formula or maybe a script that would ...
Set conditional formatting to use a checkbox to change row color ...
https://support.google.com/docs/thread/189010230/set-conditional-formatting-to-use-a-checkbox-to-change-row-color-individually-throughout-the-sheet?hl=en Nov 17, 2022 ... I am attempting to set up a sheet that utilizes check boxes so that it will allow me to hit a check box and change that rows color individually.
Conditional formatting on one box, dependent on content in another ...
https://support.google.com/docs/thread/26310576/conditional-formatting-on-one-box-dependent-on-content-in-another-box?hl=en Jan 21, 2020 ... Basically, change the color of the text to match the color of the cell if I have no hours listed for them. Now, these cells can reference ...
Google Sheets Excel: How Can We Use Multiple Font Colors Within ...
https://support.google.com/docs/thread/99933050/google-sheets-excel-how-can-we-use-multiple-font-colors-within-the-cell-like-desktop-excel-allows?hl=en Feb 26, 2021 ... Or are you trying to change the color of the output of a formula? If you're changing hand entered values, you have to select/ highlight the ...
I want the whole row to change color based on dropdown box color ...
https://support.google.com/docs/thread/197460225/i-want-the-whole-row-to-change-color-based-on-dropdown-box-color-not-just-single-cell?hl=en Jan 15, 2023 ... Click Format Conditional formatting. Under the "Format cells if" drop-down menu, click Custom formula is. If there's already a rule, click it or ...
Change font color of a specific text in a single cell based on another ...
https://support.google.com/docs/thread/177592464/change-font-color-of-a-specific-text-in-a-single-cell-based-on-another-cell?hl=en Sep 2, 2022 ... If I understand you correctly it is possible with a custom conditional formatting formula. Please share a sample spreadsheet that shows ...
Changing color of range based on text only applying to 1 cell in the ...
https://support.google.com/docs/thread/26107308/changing-color-of-range-based-on-text-only-applying-to-1-cell-in-the-row?hl=en Jan 19, 2020 ... This spreadsheet will be used to track driver stints in endurance racing. ... To make this work a Custom formula is needed. Here is the typical ...
Change the color of text, objects, and backgrounds - Google Docs ...
https://support.google.com/docs/answer/13267978?hl=en From Google Docs, Sheets, and Slides, you can: Change the color of text, objects, and backgrounds Create custom colors through HEX values, RGB values, ...
How to change color of a cell when a new entry is input. - Google ...
https://support.google.com/docs/thread/118073389/how-to-change-color-of-a-cell-when-a-new-entry-is-input?hl=en Jul 21, 2021 ... I have a Time Trials sheet in which myself and friends will log our best track times on the new Formula 1 game. I am looking at changing the ...