-
Can't delete column, can't find conditional formatting rule that's preventing it
There was one conditional formatting rule that referenced the column in question. I deleted that rule, but still can't delete the column. Would be nice if SS would identify the any associated rules—am I missing something?
-
Lower Conditional Formatting Rules Taking Priority Over Higher Rules
Hi, I'm working on a sheet with conditional formatting now. I have two rules that specify font characteristics. The top rule specifies bold font, and the lower rule specifies strikethrough. When a row meets both rules' criteria, the font is both strikethrough and bold, while I want the font to be just bold with no…
-
Merged: Is it possible to simplify the process to set-up a reoccurring task?
This discussion has been merged.
-
Need help adding a 3rd argument to a COUNTIFS formula
Hello, I am trying to count number of late documents within a specific section of the sheet. I have been able to do it successfully using row numbers but we change rows frequently because it is a roster type list I don't want to have to edit the formula each time. The third argument I wanted to use was to use their teams…
-
Why is Dynamic View allowing me to build logic based off one set of dropdown values but not another?
I have a Dynamic View built from a report of multiple sheets. I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here: But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values…
-
One Conditional Formatting Rule Not Taking Priority
I apply a similar strategy of conditional formatting to a lot of sheets and don't usually have any issues, but on this one sheet, I have a rule that's listed above the others, but it's not taking precedent over the other formatting rules and I'm not understanding why. I have a cascade of blue colors to denote "header"…
-
Conditional Formatting Gantt Bars & Other Columns
Currently, if conditional formatting is applied to Gantt bars, the format must be applied to the "entire row". I would like the ability to apply conditional formatting to the Gantt bars and additional formatting to individual columns. Example: format Gantt bars red, yellow, and green for large, medium, and small impact…
-
How do I set conditional formatting, based on dates, to span across columns representing quarters?
Hello! I am trying to create conditional formatting based on a range of project dates that will fill cells representing quarters. For example: if the project spans 5/6/24 - 9/1/24, I want it to shade the Q2 24 and Q3 24 cells. If the project spans 5/6/24 - 1/5/26, I want it to shade cells Q2 24 through Q1 26. See the dark…
-
CountIF for a multi-select drop-down
Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because it makes the most sense for me. In the sheet summary tab, I want to be able to count how many rows need…
-
Conditional Formatting Not Working as expected
I'm trying to apply conditional formatting to a sheet and it looks like it's ignoring the conditions that I've outlined. First, when you apply more than one condition to a sheet it's an AND and not an OR, correct? Second, these are the conditions I have set. When I have both conditions enabled AND the date is in the next…
