Given the following spreadsheet:
Spreadsheet with consecutive dates in column A
I want to highlight the dates in Column A if it is a Monday or a Wednesday. I have the following conditional formatting rule
="or(weekday(a2)=2, weekday(a2)=4)"
Conditional Formatting Rules Window
This formula evaluates correctly when placed in a cell (Column C is a test, but I don’t want that in the final sheet), but nothing is highlighted in Column A. (Note: I tried changing the reference in the formula to A1, but that didn’t work either).
Does anyone know why?
