Forum Discussion
Highlighting alternate rows using conditional formatting
If your dates are proper date values rather than text strings, then 'weekend?' defined as
= WEEKDAY(thisDate,2)>5
could be used to conditionally format the weekends which could be more informative than an alternating pattern.
By the way, I agree with the earlier post that recommends the use of a table. Besides the normal alternating stripes it is possible to set that up with a 5rows/2rows repeat pattern.
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.
