-
Conditional Formatting comparing two dates
I'd like to create a conditioning formatting to highlight a cell based on the difference between two dates. Column A is the expected date of delivery. Let's say 1/1/23. Column B is the actual date I received it, say 1/5/23. I'd like it to follow this rule: Highlight Column A cell when: Received date is more than 5 days…
-
Prohibit a cell from being marked as complete
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
-
Conditional Formatting - Single Cells
Hi, I have a training spreadsheet for my staff, that has two columns, one for a required level and one for the completed level. I want it so that if the completed and required columns don't match in a particular cell, the either of the completed or required cell highlight to another colour. This will make is easier to spot…
-
Conditional Formatting (modified date not in the last 3 weeks)
I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow. Is this spmething that can be done directly within conditional formatting or should I first create a…
-
Merged: Conditional Formatting on Parent Rows within Gantt
This discussion has been merged.
-
I need to have a count down from Column A Date with the current date and show the number in a column
Colum A Date - has a date ( if in the future ) Colum B - should show me the countdown as per the current date
-
Calculate number of days per month within a date range that spans more than one year
I have a schedule that spans (2) calendar years. I want to return the number of days per month included in the range. Since I use this result for billing purposes, I have a column per month and year of the schedule the returns the number of days in that given month/year. I am running into problems once I get to the same…
-
Nested IF Formula
I would like the IF statement to return a specified value if based upon date ranges. For example, if a date falls within a range: 09/01/23 - 11/30/23 should return the value "Q1" 12/01/23 - 02/29/24 should return the value "Q2" 03/01/24 - 05/31/24 should return the value "Q3" 06/01/24 - 08/31/24 should return the value…
-
RAID Log Date Value Locking per column when status changes
Hello everyone, I have tried to find the best answer for this but I see too many threads and different responses. If anyone could help as I am new to this. I am only looking to lock in a date value on 2 columns whenever there is a status change, from when an issue is raised and then resolved. I know there is a record a…
-
Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?
I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands. I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On…