About 1,399,316 results (3,507 milliseconds)
I'd like to move a row to another sheet based on another cell's ...
https://support.google.com/docs/thread/115603351/i-d-like-to-move-a-row-to-another-sheet-based-on-another-cell-s-criteria?hl=en Jul 1, 2021 ... 2. I'd also like to be able to auto sort based on a conditionally formatted cell's color without changing the formulas. https://docs.google.
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.
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 ...
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.
Highlight a selected row - Google Docs Editors Community
https://support.google.com/docs/thread/96419545/highlight-a-selected-row?hl=en Feb 3, 2021 ... * @param {Object} e The onEdit() event object. */ function onEdit(e) { onSelectionChange(e); }. /** * Sets the cell fill color of cells in row e ...
Handling array formulae in ExcelDNA UDF
https://groups.google.com/g/exceldna/c/GyX1G_lxO5o Oct 21, 2016 ... I'm not using VBA, but even so the formula {=MultiplyThem({1,2,3,4} ... ) and I change the color of the cells by this information for the error ...
I want a cell to change colour when a date has expired - Google ...
https://support.google.com/docs/thread/231506184/i-want-a-cell-to-change-colour-when-a-date-has-expired?hl=en Aug 22, 2023 ... I'm new to google docs and I would appreciate your help with a google sheet formula. I want to monitor employees WWC expiry. I would like the ...
Conditional Formatting - to highlight overwritten formulas
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/1f5F1js21E4 May 19, 2010 ... able to identify when the contents of a cell is derived from a formula as ... Then add conditional formatting based on the following ...
Incorporating Cell color fill in an "if" logical function?
https://groups.google.com/g/microsoft.public.excel.worksheet.functions/c/HvNg78YBBP8 May 18, 2006 ... Conditional formatting CAN affect the FORMATTING of cells based on the ... color without using VBA. Gord Dibben MS Excel MVP. On Thu, 22 Jan 2009 ...
In-cell Text Formats - 2 Quick Tips
http://feedproxy.google.com/~r/PointyHairedDilbert/~3/4U0bcti6JP8/ Mar 7, 2012 ... ... function. Excel Howtos. Get all BOLD text out Excel Cells Automatically ... Excel and paste, I lose all the formatting. I've tried the option ...
Set up conditional formatting that is also case sensitive - Google ...
https://support.google.com/docs/thread/225325361/set-up-conditional-formatting-that-is-also-case-sensitive?hl=en Jul 13, 2023 ... This way you can add new valid values to the list as needed without modifying the formula I crreated. ... This formula will also ignore cells in ...
Was hoping to find a way to fill cells with color using a formula or ...
https://support.google.com/docs/thread/20465262/was-hoping-to-find-a-way-to-fill-cells-with-color-using-a-formula-or-function-but-not-cf?hl=en Nov 19, 2019 ... My goal is to color fill the cells of column "E" utilizing RGB values of Columns B:D with column "A" used as the index value.
What's the correct way to indicate an "endless" range? - Google ...
https://support.google.com/docs/thread/118059590/what-s-the-correct-way-to-indicate-an-endless-range?hl=en Jul 21, 2021 ... I have a large spreadsheet and need to setup various things (like conditional formatting) and have it extend when new rows or columns are ...
ExcelDNA and Microsoft.Office.Interop.Excel
https://groups.google.com/g/exceldna/c/cGaa-X5vlE8 Nov 28, 2017 ... My XLL functions work with WorkBook, WorkSheet, Range, Cells (value, formula, color, ...), ... My actual knowlegde is based on VBA and the Excel ...
Conditional formatting not applying to range - Google Docs Editors ...
https://support.google.com/docs/thread/222277059/conditional-formatting-not-applying-to-range?hl=en Jun 23, 2023 ... I'm selecting 2 cells and adding a conditional formatting rule soley intending to have the fill colour change in both cells when a checkbox is selected.
How do I change color of cell if Date value is after a certain date ...
https://support.google.com/docs/thread/52147759/how-do-i-change-color-of-cell-if-date-value-is-after-a-certain-date?hl=en Jun 8, 2020 ... I'm trying to change the colour of a cell based on the date in the cell and the current date. ... Format Cells If: Custom Formula Is. Custom ...
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 ...
Move Row to Bottom based on Status of cell - Google Docs Editors ...
https://support.google.com/docs/thread/146722062/move-row-to-bottom-based-on-status-of-cell?hl=en Jan 19, 2022 ... The "Completed On" column E has an array formula that attempts to insert a timestamp in the column when a checkbox is clicked. It will not work, ...
Why this excel sheet is not working when I upload it to google sheets ...
https://support.google.com/docs/thread/2425399/why-this-excel-sheet-is-not-working-when-i-upload-it-to-google-sheets?hl=en Mar 14, 2019 ... ... without having to buy excel. ... I downloaded a trial of excel and I open the VBA Editor and from the looks of things, it's only formulas.
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 ... Conditional Formatting can't tell if a cell is bold or not. CF rules are based on the value in the cell, like text or numbers or dates or checkboxes.