About 1,924,187 results (1,415 milliseconds)
Conditional Formatting - Color Scale referencing other cells/sheets ...
https://support.google.com/docs/thread/108310097/conditional-formatting-color-scale-referencing-other-cells-sheets?hl=en May 1, 2021 ... I believe conditional formatting only works in the same sheet so I've attempted (possibly unsuccessfully) to copy values over from the values sheet into the ...
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 ... I am looking to color the cell D5 green if it is greater than or equal to D4. I used Format --> Conditional Formatting and picked the "Greater than or Equal to ...
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 conditional formatting on F1 to color the cell ...
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 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 ... I am trying to highlight a cell if the text matches some text in a column of another sheet. I found a tutorial online which works but am not sure why the ...
Turn manually added values to negative, based on content of ...
https://support.google.com/docs/thread/189295841/turn-manually-added-values-to-negative-based-on-content-of-another-cell?hl=en Nov 19, 2022 ... ... based on another cells value in the same row. (It's like conditional formatting, but instead of the color change i want to multiply them with -1)
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 ... Hi, very new to sheets and trying to figure out how to get this conditional formatting to work. I'm working on a small spreadsheet to track if a ...
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 ... ... cell in B21:K21. -+0 on the end of the second RIGHT just makes sure the value is a number. ->B20 checks for all the Set #s larger than the ...
Conditional formatting based on the values in another cell and a set ...
https://support.google.com/docs/thread/249451112/conditional-formatting-based-on-the-values-in-another-cell-and-a-set-numerical-value?hl=en Dec 20, 2023 ... I have a cell that is set to count up daily (K2), and I want that cell to change color once it hits a certain value, but the values are ...
Sheets Conditional Format Color Scale per Values in One Column ...
https://support.google.com/docs/thread/121125878/sheets-conditional-format-color-scale-per-values-in-one-column-grouped-per-values-in-another-column?hl=en Aug 14, 2021 ... Does anyone know if there is a way to do conditional formatting color scales based on the values in one column, but grouped by values in another column?
conditional formatting change colour based on another cell being ...
https://support.google.com/docs/thread/162061352/conditional-formatting-change-colour-based-on-another-cell-being-empty-or-not?hl=en May 2, 2022 ... The argument passed to IsBlank() must be a reference to a cell: value - Reference to the cell that will be checked for emptiness. IsBlank ...
How to conditional format based on two conditions of another cell ...
https://support.google.com/docs/thread/34905276/how-to-conditional-format-based-on-two-conditions-of-another-cell?hl=en Mar 22, 2020 ... At the moment the conditional formatting is (essentially) highlighting the lower of the two values. I only want it to change colour if the new ...
Conditional Formatting based on checkbox value - Google Docs ...
https://support.google.com/docs/thread/129432464/conditional-formatting-based-on-checkbox-value?hl=en Oct 5, 2021 ... I'm trying to find the best way to apply some sort of conditional formatting or possibly a script that will change the color 3 cells based on the checkboxes.
Conditional formatting: colors based on percentage relation to ...
https://support.google.com/docs/thread/70779490/conditional-formatting-colors-based-on-percentage-relation-to-another-cell?hl=en Sep 12, 2020 ... I would like the color for the available amount cell to change, based on the percentage it is relative to the original monthly budget amount amount.
Conditional formatting - one cell only based on a value in another ...
https://support.google.com/docs/thread/133326083/conditional-formatting-one-cell-only-based-on-a-value-in-another-cell-each-row-column-separately?hl=en Nov 1, 2021 ... I have people whom I planned salary raises. For example for Anna the change is planned for March and I would like to color March salary so to ...
Conditional format on one date based on another cell's date ...
https://support.google.com/docs/thread/112120842/conditional-format-on-one-date-based-on-another-cell-s-date?hl=en Jun 2, 2021 ... I've already manually changed the color of the start dates that 14+ days from the submitted date, but would like this to happen automatically.
Conditional formatting based on a percentage from another cell ...
https://support.google.com/docs/thread/51910990/conditional-formatting-based-on-a-percentage-from-another-cell?hl=en Jun 7, 2020 ... You will need a rule for each different color you want to have. Here are some general "rules" about Conditional Formatting in Sheets that might help.
Conditional formatting with Custom formula referencing another sheet
https://support.google.com/docs/thread/104768984/conditional-formatting-with-custom-formula-referencing-another-sheet?hl=en Apr 2, 2021 ... Based on the possible values for Type, I would like to color the cells for that row ranging from columns B to E on Sheet1. On Sheet2 I ...
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 ... ... value of the drop-down cell beside each player's name, or filtering based on the conditional formatting formula that triggers the color change.
Conditional Format Apply Only If Cell is NOT empty - Google Docs ...
https://support.google.com/docs/thread/176199949/conditional-format-apply-only-if-cell-is-not-empty?hl=en Aug 22, 2022 ... Trying to apply conditional formatting to a row based on the value in another cell, but only those cells in the row that are not empty.