I need to make the dates in a column turn green or red depending if they are complete. There is a box of due date of the deck, the deck completion date needs to turn either green or red, based off hitting the due date or missing it- OR if the box hasn't been filled with a date when it is due. HELP, please.
As the attachment (paperclip) column is on the far left of the sheet and can't be repositioned, it's not always clear when an attachment has already been added to a row (as I often don't scroll far left to check, especially in sheets with multiple columns). Is there an easy way to use conditional formatting to identify and…
This discussion has been merged.
Hi Community I have a simple sheet with a mixture of parent and child rows. Not all parent rows have child rows. I have a very simple formula [=SUM(CHILDREN())] to sum the value of child rows for a parent row where they exist. Where there are no child rows the formula returns a "0". I use conditional formatting to change…
I have a sheet where I have individual tasks each with their own start and finish dates that can overlap. They each have a certain # of people assigned to the tasks per day. Essentially, it looks like start: 5/15/23 | end: 6/25/23 | #ofPPL/Day: 5 and for each day in between those dates there will be 5 people. The goal is…
Currently when using conditional formatting hyperlinks are not affected. It would look better if the hyperlinks are affected by the conditional formatting (for example greyed out when box is checked).
I have a conditional format setup on my sheet to grey out a row when the checkbox for row is checked. However, the link that I have setup in one of my cells doesn't grey out. Is there a setting I'm missing for this?
I have a formula that says IF(Date@row<TODAY(-14),1,0), to add a checkmark, but how do I add a formula that says once a next recurring date has been added to remove this checkmark.
Hi, I have columns for "start date" and "actual start date". If I manually enter an actual start date and it's PAST the proposed start date, I would like that row to have red font. I can't see a way to do this. Using any date column it seems the only option is to use an actual date in conditional formatting. Any…
I cannot understand what I'm doing wrong - I have two columns titled 'Owner First Name' and 'Owner Last Name'. There is a third titled 'Registration Type' I have conditional formatting setup that if the cell is blank to turn it red. I added another condition that if the Registration Type is 'Partnership' to ignore and to…
