-
My conditional formatting is not showing consistently in my reports, what did I do wrong?
Hello, So I have several conditional formatting rules set up and after adding a few more that were needed for my team, some of the formatting is not showing on my team's reports for all the rows. Example: I have a format rule for a drop down list column where when the word Need is used, that cell should turn yellow. The…
-
Control Center - Global Update for Conditional Formatting
We would love to have the capability to push new conditional formatting using global update for provisioned project sheets. We have over 200 projects and whenever we get new ask for new conditional formatting (since things change all the time), it's a huge manual hours to go through and update each provisioned project with…
-
Is there a way to identify and highlight that a particular contact has overlapping dates?
Staff assignment sheet I want to be able to highlight rows that have the same person assigned to overlapping dates. Assignment is a Contact list dropdown and the dates is a Date column.
-
Timeline View Conditional Formatting Color Not Updating in Real time and requires refresh of page
I have a grid sheet with formulas and conditional formatting set up so that when the Status of a row/task changes, the row color and icon update accordingly (e.g., when Status = “Staged,” the row turns yellow and shows a yellow icon). These colors have always carried over correctly into Timeline view. Previously, if I…
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
-
More Color Options - Make Custom Colors in Conditional Formatting
I would love to have the ability to make custom colors or use color hex codes in the conditional formatting window.
-
Conditional formatting for Reports
The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I am…
-
Timeline View: conditional formatting turns everything gray?
When using the Group feature in Timeline View, I appreciate how each group is given its own color. However, I would like to use conditional formatting to color bars a different color when a condition is met. However, when testing this, every time I use any type of conditional formatting, it turns the entire timeline view…
-
Pull date from text string for conditional formatting
I have a text string column that always ends with "by [date]" on a sheet that someone else manages. They want to keep the text in that paragraph instead of using a separate date column, but they want conditional formatting on the date column… I have a formula that pulls the text value from the Next Deliverable(s) column:…