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.

Jun 3, 2021 ... CF rule would do the trick. The rule is applied to column A2:A, and the $C is necessary to say check the value in column C, but ...

Jul 31, 2019 ... ... conditional formatting "reads" the formula in the cell instead of the value. Here's how I set up the spreadsheet: I entered (a longer ...

May 10, 2019 ... To highlight a row based on a single column you will use the $A1 variation. Unlike normal formulas conditional formatting will not automatically ...

Dec 12, 2019 ... Rows 5 and 9 should not be highlighted, the others should be highlighted based on this, correct? I just used your formula and it appears to ...

Apr 19, 2019 ... ... 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 formula works.

Oct 29, 2021 ... Conditional formatting will not do that for you. If you are getting the numbers from a formula, you might be able to have some IF functions ...

Mar 31, 2021 ... I'm trying to highlight an entire row based on the selected value from my drop down list. I did the custom formula “=$D2=“in Progress”” but I keep getting ...

Jul 30, 2020 ... To highlight a row based on a single column you will use the $A1 variation. Unlike normal formulas conditional formatting will not automatically ...

Apr 27, 2022 ... ... Conditional Formatting and the Boolean value that I had added. https ... Edit: I changed the formula to use MATCH and UNIQUE instead of ...

Apr 9, 2019 ... I'm trying to identify which cells in a particular column do not contain a formula. Was thinking that I could search in formulas, but not ...

Mar 22, 2020 ... You can use the Sheets function ... No, Conditional Formatting rules do not work that way. There is no memory of what order the values were ...

Dec 2, 2019 ... ... formulas for you but does not show that change in other cells. ... cells will be adjusted based on their offset from that top-left cell.

Sep 15, 2020 ... In the cell B4 I want to see a drop-down menu with a list. The values inside won't come from a single table but from two, depending on the value ...

Apr 2, 2021 ... I would like to format a row of cells in Sheet1 based on values located in cells in Sheet2. ... no matter in which position/cell in row A of ...

Jan 24, 2025 ... ... not turning the numbers the correct colors based on the formula. I ... formula for each cell. In cell B4, it applies the formulas as ...

Sep 22, 2022 ... It works just fine in Excel. I have a value of 1 in cell A1. I have a value of 5 in cell B1. In cell C1 =sum(A1,B1). It produces the number 6.

Apr 10, 2022 ... ... formatting to all cells, without updating the reference cell ... Right, ImportRange() fetches values only - no formulas and no formatting.

Apr 30, 2021 ... The colours, if you still want them, can be applied automatically using conditional formatting, triggered by the text value in column C - green ...

Jul 5, 2022 ... Both are using the same formula (=B12=MAX($B$12:$J$12)). What I would like is to keep the rule of highlighting the highest value, but I want to ...