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
5:285:305: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 :)
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
Hello, I am tracking due dates using networkday function. Let's say for example in column A=Due date, column B=# of days until due using today(), and column C=date submitted. How can I stop column B in a specific cell from counting down, if there is a date entered into its relative column C cell?
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?
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?
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?
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!
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.
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!!
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.
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.
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
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.
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.
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
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... 🙏
This is great and I like it a lot. I'm trying to make a spreadsheet for my pick-up jobs. I need a little more direction and help. Would you be able to email me so we can conversate a little further. I am doing it but I'm not getting what I need.
I love how you don’t waste our time with volumes of unnecessary superfluous narrative. Great view mate.
Much appreciated!
Exactly what I needed!! Thank you!!
You are so welcome!
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
Excellent content!! Congratulations.
This was really helpful. Thanks
You're welcome!
Thank you so much sir! 3rd time taking MS-211. 🤞🤞🤞
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 :)
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
try use DATE function.
I have the same problem.
Hello Chris. Could you please help with a conditional formatting where I need to highlight cells which has date of more than a year ago from today?
Here you go drive.google.com/file/d/1rhfiqlBLF3O4hVypaWN2GUxkLkFYUsFz/view
How can I highlight the rows
How do you do conditional formatting if i want to add an amount every 1st of the month? i wanted it to be updated every 1st of the month.Thank you
Hello, I am tracking due dates using networkday function. Let's say for example in column A=Due date, column B=# of days until due using today(), and column C=date submitted. How can I stop column B in a specific cell from counting down, if there is a date entered into its relative column C cell?
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?
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?
Hi Chris I'm using the cell
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?
Is there a way to border a cell who's number simply matches the number of today? So if today is October 1, then border any cell that has a 1 in it?
I used Green fill but you could you a border. drive.google.com/file/d/1Ke7Ci_uLnpj4DFeSkQ78GZQMhWIwPmUr/view?usp=drivesdk
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!
Type the TODAY() function and use XLOOKUP in the cell next to it. drive.google.com/file/d/1z_ppi_c_zlBxKdznlNHhHvdZEXU5NEjg/view?usp=drivesdk
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.
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!!
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.
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.
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
Hi Chris, I need your help, how to set automatic title change formula in excel when the date is expired
How would I not use todays date, but a specific date in a cell plus 60 months. I am trying highlight licenses that are about to expire. Thanks!
But what if I want this: show all Case Management Date with =
Hello, is there a way to search for cells in multiple sheets of an excel file that contain date within April of 2023 (for example). Thank you
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.
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.
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
Please use zoomed in picture for demonstration
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... 🙏
Nope. If my job wants me to learn this, they can pay to send me to a workshop. I am not committing my free time to it lol.
This is great and I like it a lot. I'm trying to make a spreadsheet for my pick-up jobs. I need a little more direction and help. Would you be able to email me so we can conversate a little further. I am doing it but I'm not getting what I need.