Forum Discussion
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...
=ISODD() or ISEVEN() on date field will work. it will show all rows in same color for specific date.
have you checked this yet ?
>>WHY the formula works...
The date field in Excel is internally stored as number. For example Aug 25, 2019 is 43702, Aug 26, 2019 is 43703 etc. When you apply a Odd() or Even() on this field, you will get TRUE or FALSE on alternative dates. Hope this helps.