Works Great! Thank you. I transcribed this into a Word document that I’d be happy to share.

@Somelittletips-hw5ju

Ай бұрын

I'm sorry if the sound in the video is not very good. But the main thing is useful information.

Such a good idea, thank you! It was easy to follow

@Somelittletips-hw5ju

2 ай бұрын

Glad it was helpful!

ummm..how about using =MOD(Row()...function, am not quite understand if there's T/F condition, thank you for guidance

Great video tip. Thank you!

@Somelittletips-hw5ju

4 ай бұрын

Thanks for the feedback

@phandongexcel

3 ай бұрын

I like this video ❤❤❤❤

Thanks!

@Somelittletips-hw5ju

3 ай бұрын

Thank you for your feedback, I am very glad.

Problem is, until ms implements this functionality, using these tricks will: - require vba and hence saving file as xlsm and all the associated security nuances - and often reset the undo stack as some vba commands do, depending on implementation. Haven't tried this one and looks like it probably shouldn't, but many others do.

Hello thank you for the video and instruction. Question: I noticed when i save the changes after putting "ActiveCell.Calculate" and close the program, then re-open in, i have to always re-enter ActiveCell.Calculate in order for it to work smoothly. Is there any way to have it working smoothly all the time than having to re-enter ActiveCell.Calculate every time i open file? Thank you.

@Somelittletips-hw5ju

3 ай бұрын

hello, when you save a document, that is, you do a standard action. File-->Save as-->This PC(browse)--> and in the menu that appears, in the "save as type" item, select "Excel Macro-Enabled Workbook". And now you will not have to do all the actions again. Write later, did you succeed or not?

But i cant save ?

How do you make this work if you have other conditional formatting?

@Somelittletips-hw5ju

26 күн бұрын

Hello. As I understand it, your problem is that when the row highlighting macro is running, it replaces the conditional formatting you have configured. Do you want this not to happen and for highlighting and conditional formatting to work at the same time?

@evolvelearnapply

26 күн бұрын

@@Somelittletips-hw5ju hi! Correct!

@Somelittletips-hw5ju

26 күн бұрын

@@evolvelearnapply Good afternoon. I'll try to figure this out. I'm a little busy right now. But as soon as I have some result, I will definitely write to you.

@evolvelearnapply

26 күн бұрын

@@Somelittletips-hw5ju no rush! We will both learn something new! Thank you!

@evolvelearnapply

20 күн бұрын

@@Somelittletips-hw5ju hi! I’ve figured it out. The workbook has to be saved as an XLSX file, that fixed it.

That is some witchcraft!

@Somelittletips-hw5ju

2 ай бұрын

When creating the video, not one witch was harmed :)

Voice not clear