Sign in to join the conversation:
is there an ability to set a conditional format based on two columns in the same row:
completed (column) date is later than the due (column) date – the cell turns red
completed date entered is before (or after) today's date
Yes, there is! Thought its kind of hidden. After you set up a conditional formatting you have to click on the arrow to the left of the condition and add another condition. See Screenshot.
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
