About 1,982,641 results (2,966 milliseconds)
Filling a cell color with an If statement in Google Sheets - Google ...
https://support.google.com/docs/thread/88176015/filling-a-cell-color-with-an-if-statement-in-google-sheets?hl=en Dec 11, 2020 ... I entered =IF(C4="******",1," ") into a box, but all it did was enter the number 1 into the box when I'm trying to change the box fill color, ...
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 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 ...
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 ...
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 ...
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 ... (1) Change cell color for a row if the date for that row is on a Sunday: ... (3) Change the text color to red for any cell on the spreadsheet ...
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 ... If the date in the cell is 14 days or less away from current date it is red. I understand that it is a conditional formatting rule, however I am ...
I need conditional formatting to change the color of a cell if I input a ...
https://support.google.com/docs/thread/6337198/i-need-conditional-formatting-to-change-the-color-of-a-cell-if-i-input-a-hyperlink?hl=en May 17, 2019 ... I need conditional formatting to change the color of a cell if I input a hyperlink. I have a Google Sheet that I use to track the arrival of ...
VBA Code; need linked cells to change color if condition met
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/gIs8xRoweBE Aug 31, 2007 ... Microsoft Office EXCEL 2003. How do I get the cells that are linked to another worksheet to change colors if a condition is met. I will need ...
changing colors of cells depending on current time - Google Docs ...
https://support.google.com/docs/thread/157721948/changing-colors-of-cells-depending-on-current-time?hl=en Mar 29, 2022 ... ... function only updates when you change something in your sheet, eg. by editing any cell. I'm not sure if changing the format of a cell, like ...
Format Cell Color After Time Has Passed - Google Docs Editors ...
https://support.google.com/docs/thread/154153969/format-cell-color-after-time-has-passed?hl=en Mar 9, 2022 ... Column B to change color if they are 8 days or later than a date in column A? Hi B. Craig,. Use this conditional formatting custom formula rule ...
Conditional Formatting Color Change - Google Docs Editors ...
https://support.google.com/docs/thread/206615318/conditional-formatting-color-change?hl=en Mar 17, 2023 ... I want all (3) cells (O,P,Q) in a respective row to turn dark grey if the dollar value in cell P is $0 but all (3) to turn Blue if there is a dollar value ...
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 ...
Automatically change cell color based on other cells' date range ...
https://support.google.com/docs/thread/240651281/automatically-change-cell-color-based-on-other-cells-date-range?hl=en Oct 24, 2023 ... As for the conditional formatting rule: Apply To Range: I12:BP18. Format Cells If: Custom formula. Custom Formula Is: =AND(DATE(YEAR($E12) ...
CONDITIONAL FORMATTING - to apply color to 2 cells only (NOT ...
https://support.google.com/docs/thread/46826820/conditional-formatting-to-apply-color-to-2-cells-only-not-the-entire-row?hl=en May 14, 2020 ... ... column A and if 6 is found, the formula will be TRUE. When it's TRUE, the row will change color. I noticed that you have a formula with A2:A ...
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.
Cell color based on Current time. - Google Docs Editors Community
https://support.google.com/docs/thread/118874259/cell-color-based-on-current-time?hl=en Jul 27, 2021 ... What I would like to try and do is make that come back column have a formula that changes the color of that cell when a time is in it, and then ...
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.
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 ... Hello Felipe Bachian,. Conditional Formatting rules can apply formatting, including font color, based on rules you set up, like Format if text ...
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 ... ... IF there is any content in cells C6:P6. Basically, change the color of the text to match the color of the cell if I have no hours listed for ...