color stripping of duplicate rows in Excel

Question

Hello,

I need to highlight all rows of similar cells in a column with alternating color, simple single color for all similar rows, on and off like below screenshot

I did not find any suitable way by searching the web.
Appreciate any help. Thank you,

Answer 1

@AHMED MORSY

For the example you provided, please select row 2:24, use Conditional Formatting, click New Rule, select Use a formula to determine which cells to format, enter this formula =ISODD($A2), then in Format, choose a color in Fill tab,click OK.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.