Hi Chris your breakdown was just what I need to able to create a date AND function/rule where if the date was past today's date AND the cell wasn't empty the cell would change read. Spoke very well and slowly done allowing me to colour and rewrite for my work. Big thank you again for your help
Hey Chris,, Can you have a simple formula with dateif in a ifthen formula,, such as =IF(c3>0,DATEDIF(A8,A9,"d"),0 ? I'm using if column c3 has no values, then count days. Thank you!!
I'm having a heck of a time figuring out how to do something and was curious if you had any ideas. I have a simple spreadsheet. Column A is dates going down by day and column B is a bank account balance for that Rows date. I have a cell on the top of the spreadsheet that I would like to display the balance from column B for whatever the current day is. Again the dates are in column A. Any ideas? Love your content!
How would I create a conditional format formula for a collum with different expiration dates? for example: I completed a course that requires recertification in 12 months, but a coworker finishes the course next week so she would have a different recertification date.
Hi! I'm having a hard time trying to conditional format cells if it's more than x amount of working days past the date logged, AND if the status = open, AND if the current cell is blank. I keep getting error messages whatever way I try to type it. (date logged is in cell F2, status is in D2, and current cell would be G2). How do I write this formula? Thank you!!
please i am trying to check; in a row that contains 20cells with different values, if each of the values are greater than a certain number, then the cell that is greater than that certain number should be = 1?
I was really hoping this would answer my question. Google isn't helping at all. my end date for my classes are in column E (starting in row 4) and I want column F to say COMPLETED when that date is equal to or less than today's date. Every time I search, it's how to highlight the cells with the dates or how to populate the dates themselves.
Hey! I am trying to do this but without the today function , simply just using a date given to me. It does not work though either highlighting everything or nothing is it a problem with my computer or is there a way to fix jt
Chris Any chance you can tell me how we can compare row 1 date row 2 [6digit number] need to find if any match from row3 date and row 4 number[6 digit ] Plz help how we can do easy way Really appreciate your help Thanks
Do you know if I can evaluate if an excel cell (let's say C3) is "Sat" or "Sun", and if it is, a can use another range of cells to be coloured by light gray? =IF(OR(C3=”Sat”,C3=”Sun”). C6:AG15 to be coloured gray?
Hi Chris! Loved your video! Can you tell what I'm doing wrong in this formula? Trying to highlight a cell based on the word current in one cell and a date within the next 60 days in another. =AND(F2="current",L2=
Two methods. On the left is Conditional formatting. On the right are YEs or NO in column c using the IF function. drive.google.com/file/d/14Nv0XJxlYuufsIR7477nF5xuuMJSS1oq/view?usp=drivesdk
Please help - I have a table with customers, their requests, the delivery deadlines, and a last column is where I have dropdown list with the status of the order - cancelled, delivered ect. So, is there a way to format so that once im over the delivery date, whole row changes colour, but when I set the status to "delivered" it changes to a different colour?
5:28 5:30 5:31 Hey, is it possible to make it based on multiple specific dates as example, there are certain days where no one will be at work, so you don't want information send out on those days Example on formular I'm using but split into multiple conditional formating, one for each date a year where no one will be working: $L2=DATEVALUE("24-12-2024") How I'd assume it could look like: $L2=DATEVALUE("24-12-2024" OR "01-04-2024" OR "09-05-2024) Is it possible to merge all dates into one conditional formatting? Thank you :)
Hello!! Help please, I created a formula to see if the payment method is ach or check then choose the due date and see if it is greater than a certain date. If(K5=''Ach'',if(J5>$O$3"Don't Pay","PAY")). The problem I'm running into is when the date equals the same date it'll still say Don't Pay. I tried to reverse the formula and even add an equal sign but it doesnt acknowledge if the dates are the same.
Hello, Could you help with a conditional formatting where I need to highlight the bookings for the preceeding week beginning on Sunday? Eg today is Wednesday 11th April 2023 and the highlight should apply for all days after Saturday 15th April or on a Sunday 16th April onwards.
Hi Chris...could you please help with a conditional formatting where I need to highlight cells which has date difference (of order date and delivery date) more than 7 days ?
If you want to keep it easy, add a helper column. Do the formula = delivery date - order date. Select the answers and Conditional Formatting, any date greater than 7 highlighted in some color.
hello, I am from the Philippines, and I'm looking for a video on how to change color in a row by month, tired of watching a video that is not wanted to, I am working on a small business at my brother's water station, finding how to make easy on how AR being paid by a month or by dates, I know you know is AR for... ☺Account Receivable is applying for payment by date and color. What I wanted po in a row... please help me po... 🙏