How to Highlight Every Other Row in Excel (Quick and Easy)

Today we’re gonna have a look at how to highlight every other row in Excel, quick and easy, no matter the size of the data table. Ready to start?

To highlight every other row use this formula:
=isodd(row())
=iseven(row())

Don’t miss out a great opportunity to learn:

How to Create Filter in Excel

How to Use Conditional Formatting in Excel

Excel Tips & Tricks for Becoming a Pro

================

❤️ Become a Patron:
Do you find our tutorials useful? Join this channel and become a patron

================

⏱️Timestamps⏱️
0:00 Intro
0:27 How to Highlight Every Other Row in Excel
1:25 How to Format Highlighted Rows
2:28 How to Highlight the Even Rows
3:13 How to Remove the Formatting From the Table

================

Is this your first time on EasyClick? We’ll be more than happy to welcome you in our online community. Hit that Subscribe button and join the EasyClickers! :)

Transcription How to Highlight Every Other Row in Excel (Quick and Easy)

Got Microsoft Office 365? Get it here

Connect:

Screen Recorder & Video Editor:

#MicrosoftExcelTutorial #ExcelQuickAndEasy #EasyClickAcademy

[tmsgacct]

Short and to the point. Excellent stuff!

[sajidtandur]

Great sir...thank you ..today I learned abt Q code.

[dforyou-informativetipstra]

Wow….these features are i saw in my daily working life ….but i dont know how to apply these these features…your channel helping me and thousands to apply all these excel features….thankyou team🙏

[rileysosmileyy]

This was super helpful and so easy to do! Thank you!!

[allybellason]

Thnkyouuu this save me from endless manual highlightingg

[binhchow]

It is great way to use Excel. Thank you.

[bkhudkhudia]

It is very helpful for me while preparing retailer's list. Thank you. 🙏

[MA]

It was amazing to learn with you, your tutorial are alway very simple to understand. Thanks for helping us learn!
I have a scenario where I have data in excel worksheet not in the table; in Column B2 to G2 and Row 2 to Row 10. I want to highlight every 4th row, but I don't want to highlight the entire 4th row, only from Column C2 to E2. Is it possible to highlight in this way?

[patriktajnai]

Thanks, its working !! super easy super :)

[RodsshopOrg]

The only issue I have is that once filled, it removes the grid in the filled cells. In your video, it does not. I did a VBA edit but that only works using the fill color feature, conditional formatting overrides it. How do you make the grid work like in your video?

[realrobot]

good work, i have a question
how to convert curency to text in excil?

[ann.]

How do I highlight every other 2 rows? Thank you!

[gio-yjen]

In MAC how do you do it? as it is different. It just shows Style, Maximum, and Minimum options

[noonekiran]

Pls mke piviot table and dash boards of 1 vdos

[robyncove]

Doesn’t work, says the formula is missing an opening or closing parenthesis