About 1,526,708 results (4,337 milliseconds)
Conditional Formatting being applied when dragging numbers ...
https://support.google.com/docs/thread/128176836/conditional-formatting-being-applied-when-dragging-numbers-between-cells?hl=en Sep 27, 2021 ... Is not empty: For cells that have a number. It was working before where I could drag the number down with out changing the background color but ...
Change background color in the cell with the highest value (numbers)
https://support.google.com/docs/thread/9390834/change-background-color-in-the-cell-with-the-highest-value-numbers?hl=en Jul 6, 2019 ... You want to set up a conditional format rule. range B2:H. select custom formula option with custom formula. =B2=max($B2:$ ...
How can I make a cell be a certain color based on number and ...
https://support.google.com/docs/thread/158897924/how-can-i-make-a-cell-be-a-certain-color-based-on-number-and-checkboxes?hl=en Apr 7, 2022 ... I am trying to format a sheet where a column with numbers in it would be color coded. I am trying to make it so that if the number is in a ...
Is there any way to put possitive numbers in a color and negatives in ...
https://support.google.com/docs/thread/10408874/is-there-any-way-to-put-possitive-numbers-in-a-color-and-negatives-in-other?hl=en Jul 22, 2019 ... Hello! I want to put in a cell the number in green if it's possitive and red if it's negative. (The cell can change their value so I can't ...
Change color of Numbers in Cell - Google Docs Editors Community
https://support.google.com/docs/thread/56755876/change-color-of-numbers-in-cell?hl=en Jul 2, 2020 ... Paste the script in Tools > Script editor, choose Run > Run function > onOpen and go back to the spreadsheet to see the menu item. It will show ...
How to sum the numbers in colored cells - Google Docs Editors ...
https://support.google.com/docs/thread/15935924/how-to-sum-the-numbers-in-colored-cells?hl=en Oct 3, 2019 ... ... numbers in the red colored cells. And also updates when I change the color of a cell. The only function I could find out there doesn't work ...
Conditional Formatting based on the cell color I choose - Google ...
https://support.google.com/docs/thread/40728058/conditional-formatting-based-on-the-cell-color-i-choose?hl=en Apr 17, 2020 ... However, after sometime I change the first serial code cell color to red and would like that serial number to then be copied onto a "Summary ...
Conditional formatting to highlight when text is entered where only ...
https://support.google.com/docs/thread/117475026/conditional-formatting-to-highlight-when-text-is-entered-where-only-numbers-go?hl=en Jul 16, 2021 ... We want to make a cell change color if they should accidentally type in text where a number belongs. ... Empty cells and cells with numbers ...
How do you stop Google sheets from changing how cells look when ...
https://support.google.com/docs/thread/33455386/how-do-you-stop-google-sheets-from-changing-how-cells-look-when-inputing-numbers-text-into-a-cell?hl=en Mar 13, 2020 ... First is likely a stray Conditional Formatting rule causing cells with content to be filled that dull green color. For number formatting, a ...
How to make text change depending on a range of numbers ...
https://support.google.com/docs/thread/148103039/how-to-make-text-change-depending-on-a-range-of-numbers?hl=en Jan 27, 2022 ... If L3=100-199, M3=2, and so on. I would also like for the color of the the cell to change depending on what number is displayed. So if M3=2 ...
Conditional Formatting Blocks of Cells Based on a Dropdown list in ...
https://support.google.com/docs/thread/149037702/conditional-formatting-blocks-of-cells-based-on-a-dropdown-list-in-another-cell?hl=en Feb 2, 2022 ... Once you understand all the functions and are ready to use this formula without seeing the numbers, change the cells text color and cell color ...
Conditional formatting cells (which contain numbers & text) based ...
https://support.google.com/docs/thread/5485364/conditional-formatting-cells-which-contain-numbers-text-based-odd-or-even-numbers?hl=en May 4, 2019 ... ... cells containing even numbers and color them using a different color. ... I forgot to change the setting so anyone can edit. Here we go again ...
How to apply conditional formatting to even and odd numbers ...
https://support.google.com/docs/thread/154362533/how-to-apply-conditional-formatting-to-even-and-odd-numbers?hl=en Mar 10, 2022 ... I want a subtle change to the background color of a pair of cells depending on whether or not the value is even or odd. Using the ...
Google Sheets: Using conditional formatting to fill cells with a ...
https://support.google.com/docs/thread/63288194/google-sheets-using-conditional-formatting-to-fill-cells-with-a-number-and-color-based-on-range?hl=en Aug 6, 2020 ... Google Sheets: Using conditional formatting to fill cells with a number and color based on range. Hi! Looking for some help setting up a ...
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 do you change the color of the phone number? - Sites ...
https://support.google.com/sites/thread/248970800/how-do-you-change-the-color-of-the-phone-number?hl=en Dec 17, 2023 ... The color of phone number for my business is changing when I look at it on a cell phone. Its red when I publish it to Google, but blue when I view it from a ...
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 ... I am attempting to make a condition that reads if a cell is in bold, it's own formatting changes (i.e. the colour of the cell changes if the ...
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 22, 2021 ... Only the cells with the times in will change colour and it will be one at a time. For example: Enter time (changes to green cell) > A time is ...
How to change the color of cells if responses are the same as they ...
https://support.google.com/docs/thread/55957919/how-to-change-the-color-of-cells-if-responses-are-the-same-as-they-are-being-added-to-sheets?hl=en Jun 28, 2020 ... After 5 duplicate entries have been received, the next duplicate will use the first color pair again. The number of colors could be increased, ...
Conditional Formatting when the value in a cell is greater than the ...
https://support.google.com/docs/thread/5900027/conditional-formatting-when-the-value-in-a-cell-is-greater-than-the-value-in-another-cell?hl=en May 10, 2019 ... ... change in other cells ... For instance, I would like to have the cell changed color for the largest or equal to largest number from F2 through F13.