About 1,989,510 results (2,391 milliseconds)
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 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 - 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: 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 ... CF rules are based on the value in the cell, like text or numbers or dates or checkboxes. ... Put values in cells, and use color and formatting to ...
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 ...
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 ...
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 understand that it is a conditional formatting rule, however I am not good with creating those. I saw a post from 3 years ago that had ...
Conditional formatting based on number of instances of value X in a ...
https://support.google.com/docs/thread/46018575/conditional-formatting-based-on-number-of-instances-of-value-x-in-a-row?hl=en May 11, 2020 ... I'm trying to figure out how to format a cell to change text colors depending on how many instances there are of a given value in the row.
Alternating colour rows based on cell value - Google Docs Editors ...
https://support.google.com/docs/thread/161495456/alternating-colour-rows-based-on-cell-value?hl=en Apr 27, 2022 ... ... to achieve my outcome using Conditional Formatting and the Boolean value that I had added. https://docs.google.com/spreadsheets/d/1lJ ...
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 ... But I'm not sure how to write this formula. I considered doing a conditional, but I don't know how to refer to the cells and create a condition ...
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 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 ... ... cells text color and cell color to white so no one will even know they are there. -This Custom Conditional Format Formula works for Week One.
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 ...
Conditional Formatting based on Relative Change from previous row
https://support.google.com/docs/thread/55909331/conditional-formatting-based-on-relative-change-from-previous-row?hl=en Jun 27, 2020 ... My objective is to color cells in a given column red if ... Sometimes it will color when the value increases, but sometimes when it decreases as ...
Conditional formatting for highlighting cells based on the values and ...
https://support.google.com/docs/thread/7040146/conditional-formatting-for-highlighting-cells-based-on-the-values-and-or-colors-of-other-cells?hl=en May 29, 2019 ... 1. I would like columns A & B to be highlighted in a pattern of colors throughout the whole used portion of the spreadsheet. For example, in the ...
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 ...
how to conditional format based on previous row for multiple rows ...
https://support.google.com/docs/thread/191588518/how-to-conditional-format-based-on-previous-row-for-multiple-rows?hl=en Dec 6, 2022 ... This has to continue with rows below, each turning red or green based on the value of the cell one row above. https://docs.google.com ...
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 ...
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 ... I currently have conditional formatting in column C, whereby, if the deadline has passed, the cell turns red; if the deadline is today, it's yellow; and if the ...
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?