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...
By the way, it depends on how you'd like to design the table. Sometimes even with tables it is used CF with =MOD(ROW(),2)=0 or like, especially if to give different accents on different columns.
Can you think of anything else that might go in here ! 🙂
Mind you, I wish conditional formatting worked properly with Named Ranges and Arrays. You apply the format to a range by name and CF kindly replaced it with the usual direct reference junk (that description is only my opinion). What is true is that editing the sheet then scrambles the CF range. Again, if you have an array formula that you wish to use to format the output range, CF only recognises the lead element.
p.s. Just checked, CF seems to work better with Tables.