User Profile
dtulips
Copper Contributor
Joined Jul 24, 2023
User Widgets
Recent Discussions
- 839Views0likes0Comments
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!!1KViews0likes3CommentsRe: Help with conditional formatting (dates)
mtarlerthank you! I sort of got it! If I apply the formula to one row it works fine, but when i try to apply it to all the cells in that column it wont work. this is what I used: =($E$8:$E$38<TODAY() )*ISBLANK($F$8:$F$38) is this not correct?1.2KViews0likes1CommentHelp 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.3KViews0likes3Comments
Recent Blog Articles
No content to show