About 1,187,226 results (1,303 milliseconds)
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 ... I have a google spreadsheet with numbers in colored cells (red and green). And I want a function of some kind that creates the sum of the numbers in the red ...
Filter and Import Cells Into A Second Sheet Based On A Conditional ...
https://support.google.com/docs/thread/109495483/filter-and-import-cells-into-a-second-sheet-based-on-a-conditional-format?hl=en May 11, 2021 ... ... cell beside each player's name, or filtering based on the conditional formatting formula that triggers the color change. In the end, I would ...
Generate a list based on fill color or text color - Google Docs Editors ...
https://support.google.com/docs/thread/140833144/generate-a-list-based-on-fill-color-or-text-color?hl=en Dec 16, 2021 ... ... formatting can be used by regular formulas to know which cells are which colour. If you'd like help entered directly on a Google Sheet, from ...
Can I exclude cells from a formula based on if it's filled with a ...
https://support.google.com/docs/thread/108155120/can-i-exclude-cells-from-a-formula-based-on-if-it-s-filled-with-a-specific-color?hl=en Apr 30, 2021 ... It is possible but not easy to do what you're describing. Sheets does not easily manage data based on the colours of a cell.
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 ...
Use conditional formatting rules in Google Sheets - Computer ...
https://support.google.com/docs/answer/78413?hl=en&co=GENIE.Platform%3DDesktop You can use custom formulas to apply formatting to one or more cells based on the contents of other cells. ... cells if" drop-down menu, click Custom formula is.
IF function based on cell color - Google Docs Editors Community
https://support.google.com/docs/thread/199859590/if-function-based-on-cell-color?hl=en Jan 31, 2023 ... How to do an If function based on cell color. For example, If cell A1 has green cell color then it will show a text "Approved" on cell A2.
Change tab color based on cell results - Google Docs Editors ...
https://support.google.com/docs/thread/177543444/change-tab-color-based-on-cell-results?hl=en Sep 1, 2022 ... I have an onEdit function that I've used for a while to change tab color based on the contents of a cell. I'm trying to use it in a different context and I ...
Getting color codes of font or background color from cell in google ...
https://support.google.com/docs/thread/147420647/getting-color-codes-of-font-or-background-color-from-cell-in-google-sheets?hl=en Jan 24, 2022 ... Hi :) I managed to implement my own little function in excel where I could get the font color code from a cell. After setting things up I ...
How do I create a formula for sums based on cell color? - Google ...
https://support.google.com/docs/thread/77037389/how-do-i-create-a-formula-for-sums-based-on-cell-color?hl=en Oct 14, 2020 ... In cells F45:F49, I would like a sum of the matching colored cells in column F. (Basically, adds up the time of each worker for the month.
Count Colored Cells function automatic update - Google Docs ...
https://support.google.com/docs/thread/236519817/count-colored-cells-function-automatic-update?hl=en Sep 25, 2023 ... I'm using a =countColoredCells function that counts the amount of cells with a specific color that I define. It works great except it doesn't update.
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 ... I'm working on a small spreadsheet ... Instead I'll just show the method I would use which uses a "Custom Formula" in the conditional formatting.
How to automatically format cell colors based on Booleans - Google ...
https://support.google.com/docs/thread/5542742/how-to-automatically-format-cell-colors-based-on-booleans?hl=en May 6, 2019 ... What I'd like to do is set up a formula with instructions like: for all rows, if End Use Date column is not empty, set row color to red. But I'm ...
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've tried using IF formulas to the side of the row to use multiple criteria and then use that cell to determine the color of the number ...
How to copy random cells to a new column based on fill color ...
https://support.google.com/docs/thread/8192114/how-to-copy-random-cells-to-a-new-column-based-on-fill-color?hl=en Jun 17, 2019 ... The Grocery List tab is what i would like to achieve via a formula or conditional formatting or some other clever way i'm not familiar with.
Conditional formatting based on the values of another sheet ...
https://support.google.com/docs/thread/4490297/conditional-formatting-based-on-the-values-of-another-sheet?hl=en Apr 19, 2019 ... Your example spreadsheet is in View Only mode so you will have to try this yourself. Enter the following formula into Cell B1 only. = ...
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 ... ... color code the range of days based on the hotel that person is staying at. I was able to come up with a formula to highlight the cells based ...
Status Color Dots in a column based on value of another cell (date ...
https://support.google.com/docs/thread/62163216/status-color-dots-in-a-column-based-on-value-of-another-cell-date-proximity?hl=en Jul 31, 2020 ... One of the things I've done in Excel was include color dots indicating due status (ex. ... I have a third column (F1) using a formula to provide ...
Changing Cell Color By Comparison to Values From Table Based ...
https://support.google.com/docs/thread/109509964/changing-cell-color-by-comparison-to-values-from-table-based-on-selection-from-drop-down-menu?hl=en May 11, 2021 ... ... Excel, so I don't know how one would go about creating that function. The final product would be a table with rows for specific individuals ...
How can I use AVERAGEIF using the font color as a criterion ...
https://support.google.com/docs/thread/6123889/how-can-i-use-averageif-using-the-font-color-as-a-criterion?hl=en May 14, 2019 ... ... formula, such as =(sum(E78:E570)- ... It has like 15 different functions and some will average cells based on the bg color or the font color.