-
Color Coding Calendars - Different Colors for Different Calendars, but from the same sheets?
Hello! I have a workspace with a ton of different sheets that each represent a project timeline for a single client. We are creating different reports to pull together program/client level views for things like team PTO, client due dates, internal resourcing priorities, etc. We use the calendar view of our reports…
-
Is there a way to have a cell match the conditional formatting the referenced cell has?
I'm creating a sheet where each cell is referencing a different cell on a master sheet. In the sheet I'm creating, is it possible to have the populated information in each cell match the conditional format from its reference cell? Example: In the master sheet, if the cell contains a date that is in the past - it turns the…
-
different color per row
how i can to do an automatic different color per row ? see example from excel:
-
Conditional Formatting - Dates in the past
Hi, I want to add a conditional format on a column holding dates that will highlight those dates which are over three years ago. I thought I would be able to pick "is not in the last (days)" and enter 1095, however it only shows "is in the last (days)" For now I have had to add two conditions: "is in the past" AND "is less…
-
Averaging a month and year of data
I want to average the month of April, 2022. I can't figure out the month, much less the year. I did look this up but I can't seem to get it to work. =AVG(COLLECT(Boiler Gas Usage}:{Boiler Gas Usage}, {Date}:{Date}, IFERROR(MONTH(@CELL),0)=4))
-
Merged: Ability to create the Conditional Formatting for multiple columns / Range of columns
This discussion has been merged.
-
IF formatting combined with a calculation
I am trying to include a calculation only if a certain qualitative value is met. Trying to have the column indicate "Days Over Deadline" by subtracting the "Submission Deadline from the Submission Date," but only if the "Assessment Stage" is Issued. =IF([Assessment Stage]@row)="Issued", =SUM([Submission Date]@row) -…
-
NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE!!!
Having to open each source sheet to have the conditional formatting update is not efficient. The refresh on reports and dashboards do not update the conditional formatting for each row. Every single sheet must be opened every day for them to display the correct colors (ex: 3 days away - blue, 1 day away - purple). I log on…
-
Need assistance with formula
I have this formula on a column =IF(Status@row = "Complete", "100%", ="In Progress", " %"), I want the user to be able to add in a number when the status@row is "in Progress". How can I write the formula to be able to allow the user to type in a progress level. "In progress" may be 75% or 50%
-
Make conditional formatting refresh all source pages for report and dashboard accuracy
Reports and Dashboards do not currently update the colors of conditional formatting. For instance, I have it set to change the color when it's 3 days away. Unless I open the source sheet, the reports in dashboards will not update. Even if I press the refresh button on the report or the dashboard, it doesn't actually…
