How To Highlight The Current Row In Excel

Рет қаралды 23,375

Күн бұрын

Пікірлер: 18

@Somelittletips 3 ай бұрын

How to highlight the current row if your table has conditional formatting, right here: kzbin.info/www/bejne/hJq4g2ywmsh7f9E

@adreamer9999 11 ай бұрын

Great video tip. Thank you!

@Somelittletips 11 ай бұрын

Thanks for the feedback

@phandongexcel 10 ай бұрын

I like this video ❤❤❤❤

@aymeetolander 9 ай бұрын

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

@Somelittletips 9 ай бұрын

Glad it was helpful!

@mikeleblanc9103 8 ай бұрын

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

@Somelittletips 8 ай бұрын

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

@debbyho4203 7 ай бұрын

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

@Luciano_mp 10 ай бұрын

Thanks!

@Somelittletips 10 ай бұрын

Thank you for your feedback, I am very glad.

@bluebook01 10 ай бұрын

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 10 ай бұрын

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?

@BoraHorzaGobuchul 8 ай бұрын

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.