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()
Sergei,
I attempted to insert that into the sheet that I was using, and it only registered one out of six jobs that it should of highlighted, as well as a few rows that don't even have a date on them!
I imitated it on this model
where A1 is instead of TODAY() - it works. How your data is structured?
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!
