In our case, it doesn’t matter which returntype argument we use as long as returnvalue accommodates its position. The simplest function uses the returnvalue 2; Monday is 1 and Sunday is 7.

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...

2] Highlight rows with dates earlier than today’s date or a specific date without using the Today() function. You can use this method to highlight the rows with dates before today’s date or a ...

Last year, I showed you a dynamic approach to using conditional formatting to highlight weekends in a monthly matrix-style calendar. In that article, "Use Excel's conditional formatting to ...