User Profile
Space250
Copper Contributor
Joined Feb 02, 2023
User Widgets
Recent Discussions
Re: Conditional formatting of a single cell by row
I must be missing something simple, but I am not sure how to get the Conditional Formatting Pane to allow me to change the "Applies To" section? When I double click it, it edits the original formula instead? (I am doing this on macOS so maybe that's why?) OliverScheurich1.8KViews0likes2CommentsConditional formatting of a single cell by row
Hi all, After doing some research, I am a little stuck on how to make this happen. The closest I found was this topic, but it didn't work out. I am trying to change the color of a cell based on the presence or absence of two text triggers in a given row. I calculate this at first with: =COUNTIF(C2:AG2,"JT")+COUNTIF(C2:AG2,"JK") ... this then results with usually a 0 or a 1 (occasionally a 2). What I'd like is the result of that to then trigger another cell elsewhere in the sheet to be colored or not. In English (as I don't know how to code it) If AI2 is >= 1 then format cell B2 with a color If it was only B2 that needed to be colored, this would be easy with conditional formatting. However, for my case I need this to be calculated for each individual row. In other words, B3 should change color when AI3 >=1, B4 should change color with AI4 >=1 (etc.) Thanks so much for any help!Solved2KViews0likes5CommentsHow to summarize dates on a cover sheet
Hello all, I currently have 2 sheets that are in the general format of: Client Name | Upcoming Date | Type Both spreadsheets are within the same file and I would like to add a cover sheet that basically lists all Client Names and all upcoming dates that are "this week" (or if easier, in the next 7 days) and then output a list on the cover sheet. Ideally this list would stay up to date based on the current day so that rather than searching the other sheets, it can be looked at very easily. Is this possible, and if so, how would I go about making it happen? Thanks so much!1.5KViews0likes3CommentsRe: Assistance with Date Formula
Hi HansVogelaar thanks so much for your fast response This seems so obvious and makes sense, but there is one situation where it doesn't seem to work: If D2 is entirely blank (there's no text/date/etc. entered) it results with "YES" with the formula: =IF(D2 <=TODAY(),"YES",""). Any way to avoid this? (quick note, I reversed then >= to <= as I had it backwards in my original post)1.2KViews0likes2CommentsAssistance with Date Formula
Hi there, After spending the last 45 minutes researching and trying to troubleshoot this myself, I have given up and am now seeking support. I am trying to create the following statement (written in English) If cell (call it D2) is not blank AND is today's date or after, then return "YES" otherwise, leave blank. I am able to independently make these formulas work using =IF(NOT(ISBLANK() and =IF>=TODAY() but I can't seem to make them work together. Additionally, I'd like to be able to simply create a If cell is not blank, then do the following... And that also seems to fail. Any help would be most appreciated!Solved1.3KViews0likes4Comments
Recent Blog Articles
No content to show