Forum Discussion
Highlighting a row based on the day of the week
When it could be
=INDEX($I:$I,MATCH(TODAY()+CHOOSE(WEEKDAY(TODAY(),2),1,1,1,1,3,2,1),$I:$I,0))=$I1
See Sheet2 attached where A1 is instead of TODAY()
I have it set up in the I column as mm/dd/yyyy. There are empty rows between each entry so that it is easier for the owner to read. Below is a screengrab from how I have the entries listed. The highlighting at the bottom was done by me as I was working on it, it does not relate to the issue.
EDIT: I also have a higher priority rule already in place for the N/A rows, if that makes a difference
When it could be
=INDEX($I:$I,MATCH(TODAY()+CHOOSE(WEEKDAY(TODAY(),2),1,1,1,1,3,2,1),$I:$I,0))=$I1
See Sheet2 attached where A1 is instead of TODAY()
It worked on your document, I copied it over to my work document, added =TODAY() in A1, and inserted the formula. The attached file is what happened - basically, it was highlighting the row below the date of tomorrow, instead of highlighting the actual date.
EDIT: I changed the cell that it was referencing from I9 to I10 and it fixed itself! Thank you so much for your help!
So far so good, but better if you use I1 with INDEX(I:I,.. It doesn't matter what is in your first 8 cells. If your range (I:I) starts from first row, start comparing from first row as well.
