Видео

If a timestamp is what you are looking for, Insert a check box in A2. Then enter =IF(A2=TRUE,IF(B2<>" ",B2,NOW())," ") in B2. When you check the box in A2, the date and time will display in B2.

@@TheBearDenPhotography yeah but how do you keep the "now" date from changing the next day

@@johncipolla8335 I've not had that issue to date, but I do see your point.

Probably not my guy

Just replying late in case anyone like me is watching this is 2024! The correct formula in relation to checkboxes is =AND($C2=TRUE, $D2=TRUE). You can add as many checkboxes as you like and the formula won't format any of your selected range unless ALL of them are checked.

Hey Duston, It took me a minute during free time to figure out what you need to do. Ok, you have E set to Red, F set to Blue with the validation set that the value will be 5. Go in and set a new conditional format highlighting E and F Columns. Under Format cells if select Custom Formula. Enter in: =AND($E2=5, $F2=5) and select your color. Now if you check both E and F, they should change to Green for you. Hope that helped. Beth

@@OfficeTechEDU thanks yup it worked, now im trying to find a way to check a box and have the link in a cell open with a download program. For example the link is in column A checkbox is in column B if I check the checkbox have the link open in download manager to download the link selected

Here is a better example. column A has this link ruclips.net/video/IKZSOnZIRes/видео.html "it is a link to your video for the example" column B has the name Checkboxes with Multiple Conditional Formatting "the name of your video that the link is to" and column C has the check box. What I want to do is make it so if i click the checkbox in column C it opens the link in download manager and when it comes up to save it is the video name in column B automatically so when you click save it saves the title "Checkboxes with Multiple Conditional Formatting" not link number "IKZSOnZIRes". I have 1000's of links and dont want to have to rename everyone one 1 at a time

@@dustonmeyer3770 Unfortunately, you can't add a custom formula to a checkbox.I know you can formulate that =If(B2=5, Hyperlink("youtube.com"),"") Or if it's for direct websites, you could have the name in the column so the URL auto generates =IF(B2=5,(C3&".com"),"") . but it'll only display it for your users when they click and only show the links they want. To auto-open a link I think what you're looking for is coding or script and that is beyond my scope at the moment. Wish I could be of more help. Sorry.

@@OfficeTechEDU ok thanks :}

Not that I've been able to find. You can resize your column to be to the left of the box, that might work. I know now you can insert the checkbox and go into data validation and select use custom cell values and then you change the words for checked and unchecked. Example, checked could be Event. Unchecked, Not an Event. You could also formulate it that =if(A2=TRUE,"Event","Not an Event") Sorry if that wasn't the answer you were specifically seeking.

@@OfficeTechEDU Thank you for the speedy reply - i’ll go ahead and test out those functions but yes what I ended up doing is resizing the column so that it’s not much larger than the size of the box while keeping it centered. Also added time and merged cells looks pretty good. But again will test out those functions thanks again!

I just want to say how much this means to me that you left this comment. I was telling my spouse that I didn't want to restart my videos because I didn't think anyone really got anything from them. Your comment gave me the encouragement to keep doing them. THANK YOU!

@@OfficeTechEDU Ohhhh yay how wonderful!!! Yes never worry about subscriptions or people. Do what you know is right and that what helps people and you will always be appreciated by many of us who don’t know what you give! You only need one student to be a teacher 🥸😉

um...

LMAOOOOOOOOOOOOOOOOO

For me..... =COUNTIF(D2:H2;TRUE)