User Profile
dtulips
Copper Contributor
Joined 2 years ago
User Widgets
Recent Discussions
Excel formulas
Hello! Is there a way to calculate the sum of adjacent cells based on the entered data? for example, the cell with the blue text would have the total of 12,000. Goal achieved: sum of cells that say yes amount awarded towards goal 10,000 yes 2,000 yes 8,000 no thanks in advance!!888Views0likes3CommentsHelp with conditional formatting (dates)
Hello! I want to set a conditional formatting rule where if the date in cell A is "past due" and cell B is empty, then cell B is highlighted. I also tried to do if the date in cell A is "past due" then the text changes color and reverts back to black once a date has been entered in cell B. I tried to do conditional formatting> highlight cells rules > dates occurring, but couldn't get it to change the text color for any dates that were older than "yesterday" or "last month". I tried looking up formulas, but whatever I found didn't work. Any help will be greatly appreciated!1.2KViews0likes3Comments
Groups
Recent Blog Articles
No content to show