Forum Discussion
Walter_Pek
Aug 24, 2019Copper Contributor
Highlighting alternate rows using conditional formatting
Hi all, I am constructing a simple personal budget (Income, expense) excel sheet, and listing my expenses on a daily basis. I am hoping to highlight the rows based on alternate days for easy refe...
Kodipady
Aug 24, 2019Iron Contributor
You can use formula
=ISODD($B2)
This will be true or false for alternating days. you can also use ISEVEN() function.
Please look at the pictures attached for details.