-
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:…
-
Automatically Delete Attachments when a condition is met
To save on storage space, I would like to automatically delete attachments to a row when a condition is met, as I would no longer need to reference those. Thanks!
-
Delete or Clear all conditional formatting
It would be great to be able to check all the conditional formatting for a sheet to deactivate or delete. There have been times where a sheet has many activated or disabled that prohibits fields from being changed because they have a conditional formatting (this is awesome btw). If there were an option to delete all (or…
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…