-
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?…
-
How do I apply conditional formatting to a single cell?
Hello, How do I apply conditional formatting to a specific cell? For the example below, when I click on the "B/C" check box, I only want to highlight the B/C within that row and not that column. Wasn't sure of the best way to do this.
-
RACSI/RACI Matrix with Conditional Formatting
Does anyone have a solution to easily set up conditional format for a RACSI/RACI Matrix without having to clone each RACSI option and setting up a conditional format for each role (in columns)? Like a formula or selecting multiple columns with the same dropdown? I created a traditional RACSI matrix for a customer but got…