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 ...

Oct 4, 2019 ... And also updates when I change the color of a cell. The only function I could find out there doesn't work and wouldn't be able to automatically ...

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.

Jul 18, 2020 ... You can write Custom Formula rules that will check to see if a value is found in a referenced column, and apply formatting color based on that.

Nov 7, 2019 ... ... excel/4711-google-sheets-filter-by-color.html. AS you can see I used this formula as explained by the site in cell D2... ... You can find out ...

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 ...

Aug 8, 2022 ... The easiest solution would probably be to insert a helper column where you have a formula that shows a true/false value based on the same logic that you use in ...

In this case, a temporary filter view will be created. Tip: When you have a formula that points to a cell inside a filtered range, note that sorting the ...

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.

Apr 30, 2021 ... Sheets does not easily manage data based on the colours of a cell, although if you search for add-ons for Sheets, you may find something that ...

Jan 14, 2022 ... Counting text values is much easier than counting colors. To best get help, please share a sample spreadsheet that shows realistic-looking ...

Jun 17, 2019 ... First you have to get the hex code of each color in the range by using a script and a custom function which is used in a formula.

Jul 30, 2021 ... Then when both are checked off, I want a different color. I think where I'm running into trouble is that I can't figure out a formula that ...

May 27, 2020 ... ... color to the new cell accordingly, but this is only in excel. Ive played around with different options and cannot seem to find a code that works ...

May 30, 2020 ... Here's how to remove the green fill color. Highlight cells C508:C512 and then go to Format > Conditional formatting.

Jul 31, 2020 ... I haven't been able to find if sheets has a function for including a colored dot (not coloring in the complete cell) in a column based on the value of another ...

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 ...

Mar 17, 2020 ... When I copy multiple cells from one spreadsheet (not sheet in the bottom tab) and paste it to another, only the values are pasted. The formulas aren't. The ...

Apr 17, 2020 ... ... cell above. I can get it to work on a single cell no problem with the drop down options and the custom formula (e.g. =G3<G2). As soon as I ...

Jul 24, 2020 ... Bolding is just a very easy way for me to check off an item, and having a way to make it change the whole colour of the cell would be really ...